DBA_LMT_USED_EXTENTS

All extents in the locally managed tablespaces

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

Related:

DBA_EXTENTS


 
Copyright © SS64.com 1999-2019
Some rights reserved