Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
PDF · Mobi · ePub


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
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
INSTANCE_NUM VARCHAR2(40)   Rollback segment owning Real Application Clusters instance number
RELATIVE_FNO NUMBER NOT NULL Relative file number of the segment header