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 | NULL | Description |
---|---|---|---|
|
|
Internal identifier for the statistics operation that the task belongs to |
|
|
|
Name of the object that this task operates on |
|
|
|
Object number of the target object |
|
|
|
Type of the target object. Possible values are:
|
|
|
|
Target size (in number of blocks) when the task started |
|
|
|
Task start time |
|
|
|
Task end time |
|
|
|
Current task status. Possible values are:
|
|
|
|
Name of the scheduler job that executes this task (for example, when concurrency is on) |
|
|
|
Estimated cost of the task (measured as elapsed time in seconds). This column is populated only when concurrency is on. |
|
|
|
For internal use only |
|
|
|
For internal use only |
|
|
|
Rank of the task among all target objects for the parent operation |
|
|
|
For internal use only |
|
|
|
Notes about the underlying task, such as the failure message for tasks with status |
See Also: