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 |