Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

Static Data Dictionary Views, 384 of 625


DBA_UNDO_EXTENTS

DBA_UNDO_EXTENTS lists the commit time for each extent in the undo tablespaces.

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

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

COMMIT_WTIME

VARCHAR2(20)

Commit time of the undo in the extent expressed as Wallclock time

STATUS

VARCHAR2(9)

Transaction Status of the undo in the extent:

  • ACTIVE
  • EXPIRED
  • UNEXPIRED

Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback