Enable & Disable ADDM reports in Pluggable Database Oracle

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);

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.