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 |