DBA_OPTSTAT_OPERATIONS

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	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