Re: How to relate a user's session and a rollback segment?

Hello,

Think this query will help you:

select xidusn, used_ublk from v$transaction;

where xidusn stands for undo segment number.

Dario

"Syltrem" <syltrem_at_videotron.ca.spammenot> wrote in message news:WWch7.55271$TW.284619_at_tor-nn1.netcom.ca...
> If a user is using some rollback segments, I know where to see how much he
> uses (v$transaction.used_ublk) but not where (what segment)
>
> Thanks!
>
> --
>
> Syltrem
> http://pages.infinit.net/syltrem (OpenVMS related web site)
>
>
>
>
Received on Fri Aug 24 2001 - 03:04:12 CDT