Re: Which rollback segment am I using NOW?

Another possibility is:

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')

--
Regards
Michel

Michel Cadot <micadot_at_netcourrier.com> a écrit dans le message : 7v8vb2$ear$1_at_oceanite.cybercable.fr...
> The following query gives you the rollback segment you are using:
>
> select r.name "Rollback used"
> from v$rollname r, v$session s, v$lock l
> where r.usn = trunc(l.id1/65536)
> and l.type = 'TX'
> and l.sid = s.sid
> and s.audsid = userenv('SESSIONID')
> /
>
> --
> Have a nice day
> Michel
>
>
> Violin <violin.hsiao_at_mail.pouchen.com.tw> a écrit dans le message :
> 3817e1ea.2049817_at_172.16.7.5...
> > Hello,
> >
> > If I connect to database, and do some insert,update,delete.
> > If I don't issue commit or rollback yet,
> > the before image will be stored in one of the online rollback segment.
> > I have RBS1,RBS2,RBS3,RBS4 and SYSTEM -- 5 online rollback segments,
> > How could I know which one the transaction is using now?
> >
> > ps.I don't need to use SET TRANSACTION USE ROLLBACK SEGMENT.
> > Thanks for your reply.
> >
> > Violin.
> > violin.hsiao_at_mail.pouchen.com.tw
>
>
Received on Thu Oct 28 1999 - 06:44:45 CDT