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

TABLE: SYS.WRH$_UNDOSTAT

Object Details
Object Name: WRH$_UNDOSTAT
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Primary Key: WRH$_UNDOSTAT_PK
  1. ColumnBEGIN_TIME
  2. ColumnEND_TIME
  3. ColumnDBID
  4. ColumnINSTANCE_NUMBER
  5. ColumnCON_DBID
Indexes
Index Type Uniqueness Tablespace Column
WRH$_UNDOSTAT_PK NORMAL UNIQUE TablespaceSYSAUX ColumnBEGIN_TIME
ColumnEND_TIME
ColumnDBID
ColumnINSTANCE_NUMBER
ColumnCON_DBID
Columns
Name Datatype Length Mandatory Comments
BEGIN_TIME DATE
Yes
END_TIME DATE
Yes
DBID NUMBER
Yes
INSTANCE_NUMBER NUMBER
Yes
SNAP_ID NUMBER
Yes
UNDOTSN NUMBER
Yes
UNDOBLKS NUMBER

TXNCOUNT NUMBER

MAXQUERYLEN NUMBER

MAXQUERYSQLID VARCHAR2 (13)
MAXCONCURRENCY NUMBER

UNXPSTEALCNT NUMBER

UNXPBLKRELCNT NUMBER

UNXPBLKREUCNT NUMBER

EXPSTEALCNT NUMBER

EXPBLKRELCNT NUMBER

EXPBLKREUCNT NUMBER

SSOLDERRCNT NUMBER

NOSPACEERRCNT NUMBER

ACTIVEBLKS NUMBER

UNEXPIREDBLKS NUMBER

EXPIREDBLKS NUMBER

TUNED_UNDORETENTION NUMBER

STATUS NUMBER

SPCPRS_RETENTION NUMBER

RUNAWAYQUERYSQLID VARCHAR2 (13)
CON_DBID NUMBER
Yes
Query Text

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


SELECT BEGIN_TIME
,      END_TIME
,      DBID
,      INSTANCE_NUMBER
,      SNAP_ID
,      UNDOTSN
,      UNDOBLKS
,      TXNCOUNT
,      MAXQUERYLEN
,      MAXQUERYSQLID
,      MAXCONCURRENCY
,      UNXPSTEALCNT
,      UNXPBLKRELCNT
,      UNXPBLKREUCNT
,      EXPSTEALCNT
,      EXPBLKRELCNT
,      EXPBLKREUCNT
,      SSOLDERRCNT
,      NOSPACEERRCNT
,      ACTIVEBLKS
,      UNEXPIREDBLKS
,      EXPIREDBLKS
,      TUNED_UNDORETENTION
,      STATUS
,      SPCPRS_RETENTION
,      RUNAWAYQUERYSQLID
,      CON_DBID
FROM SYS.WRH$_UNDOSTAT;

Dependencies

[top of page]

SYS.WRH$_UNDOSTAT does not reference any database object

SYS.WRH$_UNDOSTAT is referenced by following:

SchemaSYS
ViewINT$DBA_HIST_UNDOSTAT