5.16 DBA_ADDM_SCHEDULED_AUTOTASKS

DBA_ADDM_SCHEDULED_AUTOTASKS displays information about all automatic ADDM tasks in the database that are currently scheduled to be executed by the Manageability Monitor Process (MMON).

This view is accessible at both the CDB and PDB level and contains information about the ADDM tasks that are scheduled to be executed at each level. Oracle Autonomous Database and Oracle Cloud users can see information about the tasks that are scheduled for their PDB. Once a task starts executing, its entry is removed from this view.

Column	Datatype	NULL	Description
INSTANCE_NUMBER	NUMBER	NOT NULL	Instance number for the ADDM task
DBID	NUMBER	NOT NULL	Database ID for the ADDM task
END_SNAP_ID	NUMBER	NOT NULL	End snapshot for the ADDM task
TASK_TYPE	VARCHAR2(14)		Type of ADDM task: INSTANCE LEVEL SYSTEM LEVEL
SCHEDULED_SINCE_UTC	TIMESTAMP(6) WITH TIME ZONE		Time at which the ADDM task was scheduled to be executed, in UTC (Coordinated Universal Time) time zone

Note:

This view is available starting with Oracle Database 23ai.