Re: Which rollback segment am I using NOW?

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Thu, 28 Oct 1999 13:40:37 +0200
Message-ID: <7v9cpq$383$1@oceanite.cybercable.fr>

To state precisely:

select r.name "Rollback used"
from v$rollname r, v$session s, v$transaction t

where r.usn = t.xidusn
  and t.ses_addr = s.saddr
  and s.audsid = userenv('SESSIONID')

--
Have a nice day
Michel

Karl R. <kreitsch_at_zdnetmail.com> a écrit dans le message : 0221c012.7290e3a5_at_usw-ex0102-013.remarq.com...
> Hello,
> in the Systemperformanceview V$Transaction there is information about
> the current transaction and the currently used Rollbacksegment.
>
> Now you have to find the link from the current Statement ( v$session )
> to v$transaction and v$sqlarea
>
> Bye!
> /karl
>
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
> The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Thu Oct 28 1999 - 06:40:37 CDT