4.126 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:
  • AUTO_TASK: A standard automatic optimizer statistics collection task, which is executed automatically in an Oracle Scheduler window, known as maintenance window
  • HIGH_FREQ_AUTO_TASK: A high-frequency automatic optimizer statistics collection task, which is executed at frequent intervals and complements the standard automatic optimizer statistics collection tasks

STATUS

VARCHAR2(49)

Status of the execution of the task. Possible values:
  • IN PROGRESS: The operation is currently running
  • COMPLETED: The operation has completed successfully
  • FAILED: The operation has failed
  • TIMED OUT: The operation timed out because the time allocated for the maintenance window was not sufficient for the operation to complete

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

Note:

This view is available starting with Oracle Database release 19c, version 19.1.