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