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 |