DBA_ROLLBACK_SEGS

DBA_ROLLBACK_SEGS describes rollback segments.

Column Datatype NULL Description
SEGMENT_NAME VARCHAR2(30) NOT NULL Name of the rollback segment
OWNER VARCHAR2(6)   Owner of the rollback segment:
  • PUBLIC

  • SYS

TABLESPACE_NAME VARCHAR2(30) NOT NULL Name of the tablespace containing the rollback segment
SEGMENT_ID NUMBER NOT NULL ID number of the rollback segment
FILE_ID NUMBER NOT NULL File identifier number of the file containing the segment head
BLOCK_ID NUMBER NOT NULL ID number of the block containing the segment header
INITIAL_EXTENT NUMBER   Initial extent size in bytes
NEXT_EXTENT NUMBER   Secondary extent size in bytes
MIN_EXTENTS NUMBER NOT NULL Minimum number of extents
MAX_EXTENTS NUMBER NOT NULL Maximum number of extent
PCT_INCREASE NUMBER   Percent increase for extent size
STATUS VARCHAR2(16)   Rollback segment status:
  • OFFLINE

  • ONLINE

  • NEEDS RECOVERY

  • PARTLY AVAILABLE

  • UNDEFINED

INSTANCE_NUM VARCHAR2(40)   Rollback segment owning Real Application Clusters instance number
RELATIVE_FNO NUMBER NOT NULL Relative file number of the segment header