DBA_UNDO_EXTENTS

6.78 DBA_UNDO_EXTENTS

DBA_UNDO_EXTENTS describes the extents comprising the segments in all undo tablespaces in the database.

Note:

The status of the undo space distribution reported by DBA_UNDO_EXTENTS is correct for the undo tablespace that is active on the instance on which DBA_UNDO_EXTENTS is queried. However, due to the use of in-memory information that is different on each instance, there can be a discrepancy in the status of the undo space distribution of undo tablespaces active on other instances when queried from one instance. This does not affect undo functionality and is only a reporting discrepancy for other instances' undo tablespace space distribution status. As a best practice, query the space distribution for an undo tablespace from the instance on which it is active.

Column	Datatype	NULL	Description
`OWNER`	`CHAR(3)`		Owner of the undo tablespace
`SEGMENT_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the undo segment
`TABLESPACE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the undo tablespace
`EXTENT_ID`	`NUMBER`		ID of the extent
`FILE_ID`	`NUMBER`	`NOT NULL`	File identifier number of the file containing the extent
`BLOCK_ID`	`NUMBER`		Start block number of the extent
`BYTES`	`NUMBER`		Size of the extent (in bytes)
`BLOCKS`	`NUMBER`		Size of the extent (in blocks)
`RELATIVE_FNO`	`NUMBER`		Relative number of the file containing the segment header
`COMMIT_JTIME`	`NUMBER`		Commit time of the undo in the extent expressed as Julian time. This column is deprecated, but retained for backward compatibility reasons.
`COMMIT_WTIME`	`VARCHAR2(20)`		Commit time of the undo in the extent expressed as Wallclock time.This column is deprecated, but retained for backward compatibility reasons.
`STATUS`	`VARCHAR2(9)`		Transaction Status of the undo in the extent: `ACTIVE` `EXPIRED` `UNEXPIRED`