Enable & Disable ADDM reports in Pluggable Database Oracle

It introduced in Oracle 19c. you can configure ADDM reports for Pluggable database(PDBs).
By default it is disabled. You need to enable it manually by executing following commands:

Note:
Default value of AWR_PDB_AUTOFLUSH_ENABLED is false
In Oracle 12c, By default ADDM report is enabled at Container level.
It work same in Oracle 19c as its work in Oracle 12c.

Enable ADDM reports in PDB databases

1. Login in the PDB database.

2. Set the value of the following parameter.

ALTER SYSTEM SET AWR_PDB_AUTOFLUSH_ENABLED=TRUE;


3. Set the AWR snapshot interval greater than 0 in the PDB.

EXEC dbms_workload_repository.modify_snapshot_settings(interval=>60);


Disable the ADDM reports in PDB

1. Login in the PDB database.

2. Set the value of the following parameter.

ALTER SYSTEM SET AWR_PDB_AUTOFLUSH_ENABLED=FALSE;


3. Set the AWR snapshot interval greater than 0 in the PDB.

EXEC dbms_workload_repository.modify_snapshot_settings(interval=>0);