Re: Autonomous transaction not committed
Date: Wed, 21 Jan 2009 13:26:22 -0800 (PST)
Sorry. What I proposed was not working. Bad QA.
- On Wed, 1/21/09, Yong Huang <yong321_at_yahoo.com> wrote:
> From: Yong Huang <yong321_at_yahoo.com>
> Subject: Re: Autonomous transaction not committed
> To: oracle-l_at_freelists.org
> Cc: post.ethan_at_gmail.com
> 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
> for action_name 'LOGON'. Those "implicit"
> session logons should be,
> or at least include if I miss any possibility, autonomous
> Yong Huang