Re: Autonomous transaction not committed

Sorry. What I proposed was not working. Bad QA.


--- 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


Other related posts: