Re: Rollback Segments in use by a session?

From: <cmohan_at_iname.com>
Date: Fri, 10 Apr 1998 12:11:04 -0600
Message-ID: <6gljr7$o2r$1@nnrp1.dejanews.com>

If your question eactly means what it asks, then the only view you need is v$rollname.

select * from v$rollname; -- This will list all rollback segments, currently online, available for that session.

If you want to know what rollback segments are available for the database, issue the following SQL. This will list all online and offline rollback segments and you may bring the offline RBSs online.

select segment_name, status from dba_rollback_segs;

Hope this helps,
CM

In article <01bd62fb$5ffbe920$2207030a_at_sahmad-pc.mfa.com>, "Saad Ahmad" <saad.ahmad_at_mchugh.com> wrote:
>
> Hello !!
>
> Is there a way to find out what rollback segments are being used
> by a session
>
> Thanks
> Saad Ahmad
> saad.ahmad_at_mchugh.com
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri Apr 10 1998 - 13:11:04 CDT