Re: Autonomous transaction not committed

From: Yong Huang <yong321_at_yahoo.com>
Date: Wed, 21 Jan 2009 13:26:22 -0800 (PST)
Message-ID: <272332.74720.qm_at_web80607.mail.mud.yahoo.com>



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

Yong

  • 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
> entries
> for action_name 'LOGON'. Those "implicit"
> session logons should be,
> or at least include if I miss any possibility, autonomous
> transactions.
>
> Yong Huang
      

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jan 21 2009 - 15:26:22 CST

Original text of this message