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