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

VIEW: SYS.DBA_OPTSTAT_OPERATIONS

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

History of statistics operations performed

[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
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
FROM SYS.DBA_OPTSTAT_OPERATIONS;

Dependencies

[top of page]

SYS.DBA_OPTSTAT_OPERATIONS references the following:

SchemaSYS
TableWRI$_OPTSTAT_OPR
SYS.DBA_OPTSTAT_OPERATIONS is referenced by following:

SchemaPUBLIC
SynonymDBA_OPTSTAT_OPERATIONS
SchemaSYS
ProcedureDBMS_FEATURE_CONCURRENT_STATS - show dependent code