Home Oracle Commands Oracle Data Dictionary
v$ Performance views

USER_EXTENTS

Extents comprising segments owned by the user

Columns
   ___________________________
 
   EXTENT_ID
      Extent number in the segment
   PARTITION_NAME
      Partition/Subpartition Name, if any, of the segment
   BLOCKS
      Size of the extent in ORACLE blocks
   BYTES
      Size of the extent in bytes
   SEGMENT_TYPE
      Type of the segment
   TABLESPACE_NAME
      Name of the tablespace containing the extent
   SEGMENT_NAME
      Name of the segment associated with the extent

Related Commands:




Back to the Top

Simon Sheppard
SS64.com