Home Oracle Commands Oracle Data Dictionary
v$ Performance views

DBA_DMT_USED_EXTENTS

All extents in the dictionary managed tablespaces 

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

Related Commands:



Back to the Top

Simon Sheppard
 SS64.com