5.15 DBA_ADDM_PENDING_AUTOTASKS

DBA_ADDM_PENDING_AUTOTASKS displays information about all automatic ADDM tasks in the database that are currently being executed.

This view is accessible at both the CDB and PDB level and contains information about the ADDM tasks that were executed at each level. Oracle Autonomous Database and Oracle Cloud users can see information about the tasks that were executed in their PDB, obtain more diagnostic information on failed tasks, and manually re-execute those tasks. Once a task is executed successfully, its entry is removed from this view. Failed tasks automatically age out and are removed when the corresponding AWR snapshots age out.

Column	Datatype	NULL	Description
DBID	NUMBER		Database ID for the ADDM task
INSTANCE_NUMBER	NUMBER		Instance number for the ADDM task
END_SNAP_ID	NUMBER		End snapshot for the ADDM task
STATUS	VARCHAR2(20)		Status of the task execution
REGISTERED_TIME	TIMESTAMP(6)		Time at which the ADDM task was first registered for automatic execution
ERROR_MESSAGE	VARCHAR2(200)		If the execution of the ADDM task failed, the error message
CREATION_ATTEMPTS	NUMBER		The number of attempts to automatically start the ADDM task.
LAST_CREATION_ATTEMPT	TIMESTAMP(6)		The time of the last attempt to automatically start the ADDM task.
EXECUTION_ATTEMPTS	NUMBER		Number of times the ADDM task has attempted to be run
LAST_EXECUTION_ATTEMPT	TIMESTAMP(6)		Time of the most recent attempt to execute the ADDM task

Note:

This view is available starting with Oracle Database 23ai.