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 AI 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
CON_ID	NUMBER		The ID of the container to which the data pertains. Possible values include: 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. 1: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data

Note: This view is available starting with Oracle AI Database 26ai.