Check
v$rollstat for xact > 0.
-----Original Message-----
From: Nguyen, David M [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 04, 2003 6:24 PM
To: Multiple recipients of list ORACLE-L
Subject: Which rollback segment is currently active?I have three rollback segments which all show ONLINE. I want to drop one of them but I need to know which one should I drop. How do I find out which one is good to drop?
SVRMGR> select segment_name,owner,tablespace_name,status from dba_rollback_segs;
SEGMENT_NAME OWNER TABLESPACE_NAME STATUS
------------------------------ ------ ------------------------------ -------
RBS01 PUBLIC RBS ONLINE
RBS02 PUBLIC RBS ONLINE
RBS04 PUBLIC RBS ONLINE
Thanks,
David
