Table: DBA_ROLLBACK_SEGS
Description of rollback segments
Column Name | Description |
---|---|
BLOCK_ID | ID number of the block containing the segment header |
FILE_ID | ID number of the file containing the segment header |
INITIAL_EXTENT | Initial extent size in bytes |
INSTANCE_NUM | Rollback segment owning parallel server instance number |
MAX_EXTENTS | Maximum number of extents |
MIN_EXTENTS | Minimum number of extents |
NEXT_EXTENT | Secondary extent size in bytes |
OWNER | Owner of the rollback segment |
PCT_INCREASE | Percent increase for extent size |
RELATIVE_FNO | Relative number of the file containing the segment header |
SEGMENT_ID | ID number of the rollback segment |
SEGMENT_NAME | Name of the rollback segment |
STATUS | Rollback segment status |
TABLESPACE_NAME | Name of the tablespace containing the rollback segment |