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
