[Home] [Help] [Dependency Information]
Object Name: | CDB_OPTSTAT_OPERATIONS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
History of statistics operations performed in all containers
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 |
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;
SYS.CDB_OPTSTAT_OPERATIONS does not reference any database object
SYS.CDB_OPTSTAT_OPERATIONS is referenced by following:
|
|
|