Re: Autonomous transaction not committed
- From: Yong Huang <yong321@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 21 Jan 2009 13:26:22 -0800 (PST)
Sorry. What I proposed was not working. Bad QA.
Yong
--- On Wed, 1/21/09, Yong Huang <yong321@xxxxxxxxx> wrote:
> From: Yong Huang <yong321@xxxxxxxxx>
> Subject: Re: Autonomous transaction not committed
> To: oracle-l@xxxxxxxxxxxxx
> Cc: post.ethan@xxxxxxxxx
> Date: Wednesday, January 21, 2009, 3:14 PM
> > Is there a sesstat which I can look at to monitor the
> number of
> > active autonomous transactions in a session. I would
> like to
> > monitor this in trace or my debug package to resolve
> an issue.
>
> Interesting question. There's no statistic specifically
> for that.
> But you can infer from "implicit" session logons.
> Suppose your
> audit_trail is turned on. Audit session. Sample the value
> of 'logons
> cumulative' statistic, minus 'queries
> parallelized', minus number
> of times any job ran, minus the number of new audit trail
> entries
> for action_name 'LOGON'. Those "implicit"
> session logons should be,
> or at least include if I miss any possibility, autonomous
> transactions.
>
> Yong Huang
--
//www.freelists.org/webpage/oracle-l
Other related posts:
