DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.DBA_UNDO_EXTENTS

Object Details
Object Name: DBA_UNDO_EXTENTS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Extents comprising all segments in the system managed undo tablespaces

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER CHAR (3)
Owner of the segment associated with the extent
SEGMENT_NAME VARCHAR2 (30) Yes Name of the segment associated with the extent
TABLESPACE_NAME VARCHAR2 (30) Yes Name of the tablespace containing the extent
EXTENT_ID NUMBER

Extent number in the segment
FILE_ID NUMBER
Yes Name of the file containing the extent
BLOCK_ID NUMBER

Starting block number of the extent
BYTES NUMBER

Size of the extent in bytes
BLOCKS NUMBER

Size of the extent in ORACLE 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 date
COMMIT_WTIME VARCHAR2 (20)
Commit Time of the undo in the extent expressed as wall clock time
STATUS VARCHAR2 (9)
Transaction Status of the undo in the extent
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OWNER
,      SEGMENT_NAME
,      TABLESPACE_NAME
,      EXTENT_ID
,      FILE_ID
,      BLOCK_ID
,      BYTES
,      BLOCKS
,      RELATIVE_FNO
,      COMMIT_JTIME
,      COMMIT_WTIME
,      STATUS
FROM SYS.DBA_UNDO_EXTENTS;

Dependencies

[top of page]

SYS.DBA_UNDO_EXTENTS references the following:

SchemaSYS
TableFILE$
TableTS$
TableUNDO$
SYS.DBA_UNDO_EXTENTS is referenced by following:

SchemaPUBLIC
SynonymDBA_UNDO_EXTENTS