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@xxxxxxxxxx> wrote: > From: Tanel Poder <tanel@xxxxxxxxxx> > Subject: RE: Autonomous transaction not committed > To: yong321@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx > Cc: post.ethan@xxxxxxxxx > 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@xxxxxxxxxxxxx > > [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of > Yong Huang > > Sent: 21 January 2009 23:14 > > To: oracle-l@xxxxxxxxxxxxx > > Cc: post.ethan@xxxxxxxxx > > 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. > > -- //www.freelists.org/webpage/oracle-l