How do I check my current RBS size/extend condition and how do I increase its size? Thanks.
SELECT segment_name, extents, max_extents FROM dba_segments WHERE segment_type='ROLLBACK';
If your rollback segments are at max extents, you can increase the max number of extents as follows:
ALTER ROLLBACK SEGMENT rollback_segment_name STORAGE (MAXEXTENTS xx);
It may also be likely that your rollback segment tablespace is full. Increase the size of the tablespace by adding another datafile to the tablespace:
ALTER TABLESPACE ts_name ADD DATAFILE '/directory/file_name' SIZE xxxM AUTOEXTEND ON NEXT xxxM MAXSIZE xxxM;
This was first published in January 2008