5.222 DBA_OPTSTAT_OPERATIONS

DBA_OPTSTAT_OPERATIONS contains a history of statistics operations performed at the schema and database level using the DBMS_STATS package.

Column Datatype NULL Description

ID

NUMBER

Internal ID of the statistics operation

OPERATION

VARCHAR2(64)

Operation name

TARGET

VARCHAR2(64)

Target on which the operation was performed

START_TIME

TIMESTAMP(6) WITH TIME ZONE

Time at which the operation started

END_TIME

TIMESTAMP(6) WITH TIME ZONE

Time at which the operation ended

STATUS

VARCHAR2(49)

Current operation status. Possible values are:

  • IN PROGRESS: Operation is currently running

  • COMPLETED: Operation has completed successfully

  • FAILED: Operation has failed

  • TIMED OUT: Maintenance window was not enough to complete this operation (applies only to automatic statistics gathering)

JOB_NAME

VARCHAR2(32)

Name of the scheduler job that executes this operation (for example, a user scheduled statistics gathering job)

SESSION_ID

NUMBER

ID of the session in which this operation is invoked

NOTES

VARCHAR2(4000)

Notes about the operation, such as a failure message for operations with status FAILED

See Also: