Thanks!
--
Syltrem
http://pages.infinit.net/syltrem (OpenVMS related web site)
"Dario Bilic" <dario_bilic_at_yahoo.com> a écrit dans le message news:
9m51pn$6244$1_at_as201.hinet.hr...
> 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 - 10:24:58 CDT
