Home Oracle Commands Oracle Data Dictionary
v$ Performance views

DBA_LMT_USED_EXTENTS

All extents in the locally managed tablespaces 

Columns
   ___________________________
 
   BLOCK
      Starting block number of the extent
   FILEID
      File Number of the extent
   EXTENT_ID
      Extent number in the segment
   SEGMENT_BLOCK
      Block number of segment header of the extent
   SEGMENT_FILEID
      File number of segment header of the extent
   TABLESPACE_ID
      ID of the tablespace containing the extent
   LENGTH
      Number of blocks in the extent

Related Commands:



Back to the Top

Simon Sheppard
 SS64.com