ALTER ROLLBACK SEGMENT

Take an existing RBS on-line or off-line or change its storage parameters.

Syntax:

   ALTER ROLLBACK SEGMENT rbs_name {ONLINE | OFFLINE}
   ALTER ROLLBACK SEGMENT rbs_name STORAGE storage_clause
   ALTER ROLLBACK SEGMENT rbs_name SHRINK [TO int {K | M}]


To monitor rollback usage (waits/gets should be < 1 %)

select name, waits, gets
from v$rollstat, v$rollname
where v$rollstat.usn = v$rollname.usn;

"Never mistake motion for action" - Ernest Hemmingway

Related Commands:

CREATE ROLLBACK SEGMENT
DROP ROLLBACK SEGMENT
ORA-01555 - Snapshot too old (Rollback has been overwritten)

Related Views:

 DBA_ROLLBACK_SEGS
 V$ROLLNAME
 V$ROLLSTAT