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

VIEW: SYS.CDB_OPTSTAT_OPERATIONS

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

History of statistics operations performed in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
ID NUMBER

Internal identifier for the operation
OPERATION VARCHAR2 (64)
Operation name
TARGET VARCHAR2 (64)
Target on which operation performed
START_TIME TIMESTAMP(6) WITH TIME ZONE (13)
Start time of operation
END_TIME TIMESTAMP(6) WITH TIME ZONE (13)
End time of operation
STATUS VARCHAR2 (49)
Operation completion status
JOB_NAME VARCHAR2 (64)
Name of the scheduler job in which the operation runs
SESSION_ID NUMBER

Id of the session in which the operation runs
NOTES VARCHAR2 (4000)
Additional notes about the operation
CON_ID NUMBER

container id
Query Text

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


SELECT ID
,      OPERATION
,      TARGET
,      START_TIME
,      END_TIME
,      STATUS
,      JOB_NAME
,      SESSION_ID
,      NOTES
,      CON_ID
FROM SYS.CDB_OPTSTAT_OPERATIONS;

Dependencies

[top of page]

SYS.CDB_OPTSTAT_OPERATIONS does not reference any database object

SYS.CDB_OPTSTAT_OPERATIONS is referenced by following:

SchemaPUBLIC
SynonymCDB_OPTSTAT_OPERATIONS
SchemaSYS
Package BodyDBMS_STATS_INTERNAL - show dependent code
PL/SQL PackageDBMS_STATS_INTERNAL - show dependent code