|
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
|
NOT NULL
|
Percent increase for extent size
|
|
STATUS
|
VARCHAR2(16)
|
|
Rollback segment status
|
|
INSTANCE_NUM
|
VARCHAR2(40)
|
|
Rollback segment owning Oracle Real Application Cluster instance number
|
|
RELATIVE_FNO
|
NUMBER
|
NOT NULL
|
Relative file number of the segment header
|
