DBA_AUTO_STAT_EXECUTIONS
DBA_AUTO_STAT_EXECUTIONS displays information about automatic optimizer statistics collection tasks, which are executed by the automated maintenance tasks infrastructure (known as AutoTask).
| Column | Datatype | NULL | Description |
|---|---|---|---|
OPID |
NUMBER |
Unique identifier for the execution of the task | |
ORIGIN |
VARCHAR2(19) |
Origin of the execution of the task. Possible values:
|
|
STATUS |
VARCHAR2(49) |
Status of the execution of the task. Possible values:
|
|
START_TIME |
TIMESTAMP(6) WITH TIME ZONE |
Start time for the execution of the task | |
END_TIME |
TIMESTAMP(6) WITH TIME ZONE |
End time for the execution of the task | |
COMPLETED |
NUMBER |
Number of objects for which statistics collection was completed during the execution of the task | |
FAILED |
NUMBER |
Number of objects for which statistics collection failed during the execution of the task | |
TIMED_OUT |
NUMBER |
Number of objects for which statistics collection timed out during the execution of the task | |
IN_PROGRESS |
NUMBER |
Number of objects for which statistics collection is in progress during the execution of the task |