Re: Rollback Segments in use by a session?

Saad Ahmad wrote in message
<01bd62fb$5ffbe920$2207030a_at_sahmad-pc.mfa.com>...
>Hello !!
>
>Is there a way to find out what rollback segments are being used
>by a session
>
>Thanks
>Saad Ahmad
>saad.ahmad_at_mchugh.com

the dynamic table v$transaction has what you need.

I haven't a database at the mo, but the query goes something like this :

select s.sid, r.name
from v$session, v$transaction, v$rollname where s.sid = <sid>
and t.addr = s.taddr
and r.usn = t.xidusn -- can't quite remember the col; but it's got usn it in !

Andy T. Received on Fri Apr 10 1998 - 05:08:19 CDT