Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

DBA_UNDO_EXTENTS

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

Column Datatype NULL Description
OWNER CHAR(3)   Owner of the undo tablespace
SEGMENT_NAME VARCHAR2(30) NOT NULL Name of the undo segment
TABLESPACE_NAME VARCHAR2(30) 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