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

VIEW: SYS.CDB_HIST_UNDOSTAT

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

Undo Historical Statistics Information in all containers

[View Source]

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

CON_DBID NUMBER

CON_ID NUMBER

container id
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
,      CON_DBID
,      CON_ID
FROM SYS.CDB_HIST_UNDOSTAT;

Dependencies

[top of page]

SYS.CDB_HIST_UNDOSTAT does not reference any database object

SYS.CDB_HIST_UNDOSTAT is referenced by following:

SchemaPUBLIC
SynonymCDB_HIST_UNDOSTAT