which rollback segment in use

From: me <m1ke0_at_yahoo.com>
Date: Thu, 25 Jan 2001 05:20:23 -0800 (PST)
Message-Id: <10752.127468@fatcity.com>

> SElect * from v$transaction ;
>
> XIDUSN field gives the number or the rbs the transaction uses ..
>
> I HOPE THIS HELPS ...
>
>
> > How can I find the rollback segment my current or a particuler transaction
> > is using.
> >

---

Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/ Received on Thu Jan 25 2001 - 07:20:23 CST