DBA_OPTSTAT_OPERATION

6.223 DBA_OPTSTAT_OPERATION_TASKS

DBA_OPTSTAT_OPERATION_TASKS displays the history of tasks that are performed as part of statistics operations (recorded in DBA_OPTSTAT_OPERATIONS). Each task represents a target object to be processed in the corresponding parent operation.

Column	Datatype	Description
`OPID`	`NUMBER`	Internal identifier for the statistics operation that the task belongs to
`TARGET`	`VARCHAR2(100)`	Name of the object that this task operates on
`TARGET_OBJN`	`NUMBER`	Object number of the target object
`TARGET_TYPE`	`VARCHAR2(40)`	Type of the target object. Possible values are: `TABLE` `TABLE (GLOBAL STATS ONLY)`: Task is created to gather only global statistics of a partitioned table `TABLE (COORDINATOR JOB)`: Coordinator task for a partitioned table when concurrency is on `TABLE PARTITION` `TABLE SUBPARTITION` `INDEX` `INDEX PARTITION` `INDEX SUBPARTITION`
`TARGET_SIZE`	`NUMBER`	Target size (in number of blocks) when the task started
`START_TIME`	`TIMESTAMP(6) WITH TIME ZONE`	Task start time
`END_TIME`	`TIMESTAMP(6) WITH TIME ZONE`	Task end time
`STATUS`	`VARCHAR2(49)`	Current task status. Possible values are: `PENDING`: Task is queued for processing `IN PROGRESS`: Task is currently running `COMPLETED`: Task has completed successfully `FAILED`: Task has failed `SKIPPED`: Task has been skipped, as it does not exist any more, or its stats are not stale (applies only to only automatic statistics gathering) `TIMED OUT`: Maintenance window was not enough to complete this task (applies only to automatic statistics gathering)
`JOB_NAME`	`VARCHAR2(50)`	Name of the scheduler job that executes this task (for example, when concurrency is on)
`ESTIMATED_COST`	`NUMBER`	Estimated cost of the task (measured as elapsed time in seconds). This column is populated only when concurrency is on.
`BATCHING_COEFF`	`NUMBER`	For internal use only
`ACTIONS`	`NUMBER`	For internal use only
`PRIORITY`	`NUMBER`	Rank of the task among all target objects for the parent operation
`FLAGS`	`NUMBER`	For internal use only
`NOTES`	`VARCHAR2(4000)`	Notes about the underlying task, such as the failure message for tasks with status `FAILED`.