Re: Which rollback segment am I using NOW?

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!