Re: Which rollback segment am I using NOW?

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Thu, 28 Oct 1999 09:50:31 +0200
Message-ID: <7v8vaa$h2p$1@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 : 3818e51e.2869135_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 - 02:50:31 CDT