Table: DBA_UNDO_EXTENTS
Extents comprising all segments in the system managed undo tablespaces
| 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 |
| COMMIT_JTIME | Commit Time of the undo in the extent expressed as Julian date |
| COMMIT_WTIME | Commit Time of the undo in the extent expressed as wall clock time |
| 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 |
| RELATIVE_FNO | Relative number of the file containing the segment header |
| SEGMENT_NAME | Name of the segment associated with the extent |
| STATUS | Transaction Status of the undo in the extent |
| TABLESPACE_NAME | Name of the tablespace containing the extent |