|
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 |
ID 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 |
