Oracle 23c New Features for DBA'sADDM does not work in a pluggable database (PDB) by default, because automatic AWR snapshots are disabled by default in a PDB.
Starting 19c , To use ADDM in a PDB, you must enable automatic AWR snapshots in the PDB by setting the AWR_PDB_AUTOFLUSH_ENABLED initialization parameter to TRUE and AWR snapshot interval greater than 0.
To enable ADDM in a PDB:
- Set the AWR_PDB_AUTOFLUSH_ENABLED initialization parameter to TRUE in the PDB using the following command:
- SQL> ALTER SYSTEM SET AWR_PDB_AUTOFLUSH_ENABLED=TRUE;
- Set the AWR snapshot interval greater than 0 in the PDB using the command as shown in the following example:
- SQL> EXEC dbms_workload_repository.modify_snapshot_settings(interval=>60);
- Restrictions are there for Analysis – Check documentation
Follow Me!!!