Table: USER_EXTENTS
Extents comprising segments owned by the user
| Column Name | Description |
|---|---|
| BLOCKS | Size of the extent in ORACLE blocks |
| BYTES | Size of the extent in bytes |
| EXTENT_ID | Extent number in the segment |
| PARTITION_NAME | Partition/Subpartition Name, if any, of the segment |
| 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 |