Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E17110-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

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