Table: DBA_EXTENTS
Extents comprising all segments in the database
Column Name | Description |
---|---|
BLOCKS | Size of the extent in ORACLE blocks |
BLOCK_ID | Starting block number of the extent |
BYTES | Size of the extent in bytes |
EXTENT_ID | Extent number in the segment |
FILE_ID | Name of the file containing the extent |
OWNER | Owner of the segment associated with the extent |
PARTITION_NAME | Partition/Subpartition Name, if any, of the segment |
RELATIVE_FNO | Relative number of the file containing the segment header |
SEGMENT_NAME | Name of the segment associated with the extent |
SEGMENT_TYPE | Type of the segment |
TABLESPACE_NAME | Name of the tablespace containing the extent |