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 AI 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 AI Database 26ai.