Home Oracle Commands Oracle Data Dictionary
v$ Performance views

USER_SEGMENTS

Storage allocated for all database segments

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

Related Commands:




Back to the Top

Simon Sheppard
SS64.com