DBA_LMT_FREE_SPACE

Free extents in all locally managed tablespaces

Columns
   ___________________________
 
   TABLESPACE_ID
      ID of the tablespace containing the extent
   FILE_ID
      ID number of the file containing the extent
   BLOCK_ID
      Starting block number of the extent
   BLOCKS
      Size of the extent in blocks

Related: