DBA_ROLLBACK_SEGS

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

Related Commands: