DBA_ROLLBACK_SEGS

Description des rollback segments.

Nom de la colonne Description
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 head
BLOCK_ID ID number of the block containing the segment header
INITIAL_EXTENT Initial extent size in bytes
NEXT_EXTENT Secondary extent size in bytes
MIN_EXTENTS Minimum number of extents
MAX_EXTENTS Maximum number of extent
PCT_INCREASE Percent increase for extent size
STATUS Rollback segment status
INSTANCE_NUM Rollback segment owning parallel server instance number