RE: Autonomous transaction not committed

From: Yong Huang <yong321_at_yahoo.com>
Date: Wed, 21 Jan 2009 15:10:19 -0800 (PST)
Message-ID: <692684.52794.qm_at_web80606.mail.mud.yahoo.com>

Yes. But he still needs to differentiate between different types of recursive transactions. Right? Some are autonomous, some are code in PL/SQL block or procedure/trigger etc without using autonomous_transaction pragma, and some are PDML. I wish v$transaction had a column or a bit in flag suggesting which type.

Yong Huang

• On Wed, 1/21/09, Tanel Poder <tanel_at_poderc.com> wrote:

> From: Tanel Poder <tanel_at_poderc.com>
> Subject: RE: Autonomous transaction not committed
> To: yong321_at_yahoo.com, oracle-l_at_freelists.org
> Cc: post.ethan_at_gmail.com
> Date: Wednesday, January 21, 2009, 4:00 PM
> Hi,
>
> Every recursive/autonomous transaction has its own
> transaction state object,
> so you can join v$transaction.ses_addr with v$session.saddr
> to find out
> which transactions belong to which session.
>
> Tanel.
>
> > -----Original Message-----
> > From: oracle-l-bounce_at_freelists.org
> > [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
> Yong Huang
> > Sent: 21 January 2009 23:14
> > To: oracle-l_at_freelists.org
> > Cc: post.ethan_at_gmail.com
> > Subject: Re: Autonomous transaction not committed
> >
> > > 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.
> >
      

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jan 21 2009 - 17:10:19 CST