Extents comprising all segments in the database
Columns ___________________________ OWNER Owner of the segment associated with the extent SEGMENT_NAME Name of the segment associated with the extent PARTITION_NAME Partition/Subpartition Name,if any,of the segment SEGMENT_TYPE Type of the segment TABLESPACE_NAME Name of the tablespace containing the extent EXTENT_ID Extent number in the segment FILE_ID Name of the file containing the extent BLOCK_ID Starting block number of the extent BYTES Size of the extent in bytes BLOCKS Size of the extent in ORACLE blocks RELATIVE_FNO Relative number of the file containing the segment header
Related:
DBA_DMT_FREE_SPACE
DBA_DMT_USED_EXTENTS
DBA_LMT_USED_EXTENTS
DBA_LMT_FREE_SPACE
DBA_FREE_SPACE
DBA_SEGMENTS
Storage - Blocks, Extents, Segments