Table: DBA_LMT_USED_EXTENTS
All extents in the locally managed tablespaces
| Column Name | Description |
|---|---|
| BLOCK | Starting block number of the extent |
| EXTENT_ID | Extent number in the segment |
| FILEID | File Number of the extent |
| LENGTH | Number of blocks in the extent |
| SEGMENT_BLOCK | Block number of segment header of the extent |
| SEGMENT_FILEID | File number of segment header of the extent |
| TABLESPACE_ID | ID of the tablespace containing the extent |