USER_SEGMENTS

Storage allocated for all database segments

Columns
   ___________________________
 
   SEGMENT_NAME
      Name,if any,of the segment
   PARTITION_NAME
      Partition/Subpartition Name,if any,of the segment
   SEGMENT_TYPE
      "Type of segment: "TABLE","CLUSTER","INDEX","ROLLBACK","DEFERRED
   TABLESPACE_NAME
      Name of the tablespace containing the segment
   BYTES
      Size,in bytes,of the segment
   BLOCKS
      Size,in Oracle blocks,of the segment
   EXTENTS
      Number of extents allocated to the segment
   INITIAL_EXTENT
      Size,in bytes,of the initial extent of the segment
   NEXT_EXTENT
      Size,in bytes,of the next extent to be allocated to the segment
   MIN_EXTENTS
      Minimum number of extents allowed in the segment
   MAX_EXTENTS
      Maximum number of extents allowed in the segment
   PCT_INCREASE
      Percent by which to increase the size of the next extent to be allocated
   FREELISTS
      Number of process freelists allocated to this segment
   FREELIST_GROUPS
      Number of freelist groups allocated to this segment
   BUFFER_POOL
      The default buffer pool to be used for blocks from this segment


© Copyright SS64.com 1999-2014
Some rights reserved