DBA_ROLLBACK_SEGS

Description of rollback segments

Columns
   ___________________________
 
   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:

DBA_SEGMENTS


© Copyright SS64.com 1999-2014
Some rights reserved