RE: Which rollback segment is currently active?

[Nick Wagner]

Title: Which rollback segment is currently active?

select rs.usn, xacts active_transactions,
gets, waits, writes, name
from v$rollstat rs, v$rollname rn
where rs.usn = rn.usn

 

This may help...

-----Original Message-----
From: Nguyen, David M [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 04, 2003 3: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