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)		<p>Origin of the execution of the task. Possible values: <ul id="GUID-1E800E0E-D294-4E32-8D93-EED0B901755D__UL_G5H_DNY_2GB" style="list-style-type: disc;"> <li>AUTO_TASK: A standard automatic optimizer statistics collection task, which is executed automatically in an Oracle Scheduler window, known as maintenance window </li> <li>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 </li> </ul> </p>
STATUS	VARCHAR2(49)		<p>Status of the execution of the task. Possible values: <ul id="GUID-1E800E0E-D294-4E32-8D93-EED0B901755D__UL_FLS_CNY_2GB" style="list-style-type: disc;"> <li>IN PROGRESS: The operation is currently running </li> <li>COMPLETED: The operation has completed successfully </li> <li>FAILED: The operation has failed </li> <li>TIMED OUT: The operation timed out because the time allocated for the maintenance window was not sufficient for the operation to complete </li> </ul> </p>
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