HuckleberryDBA: AWR/ADDM Snapshot settings: CDB/PDB

get current:

SELECT con_id, extract(day from snap_interval) *24*60+extract(hour from snap_interval) *60+extract(minute from snap_interval) snapshot_Interval,

extract(day from retention) *24*60+extract(hour from retention) *60+extract(minute from retention) retention_Interval

FROM dba_hist_wr_control;

19c new feature, enable addm in pdb.

ALTER SYSTEM SET AWR_PDB_AUTOFLUSH_ENABLED=TRUE scope=both sid='*';

EXEC dbms_workload_repository.modify_snapshot_settings(interval=>60);

references:

19c New Feature Support ADDM Analysis for PDBs (Doc ID 2644341.1)

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=124474630246449&id=2644341.1&_afrWindowMode=0&_adf.ctrl-state=8xemq01j2_160

HuckleberryDBA