Has anyone experienced the 23c FREE AWR snapshots never being purged? In both the CDB$ROOT and PDBs.
Details:
- Oracle Database Version 23.3.0.23.09
- AWR retention from dba_hist_wr_control: 8 days
- No baselines (only the default SYSTEM_MOVING_WINDOW)
However, the AWR snapshots from database creation snap_id=1 onwards are still present.
Verifying using:
SELECT con_id, dbid, instance_number,
MIN(SNAP_ID) OLDEST_SNAPSHOT, TO_CHAR(MIN(begin_interval_time),'DD-MON-YYYY HH24:MI:SS') OLDEST_SNAPSHOT,
MAX(SNAP_ID) NEWEST_SNAPSHOT, TO_CHAR(MAX(begin_interval_time),'DD-MON-YYYY HH24:MI:SS') NEWEST_SNAPSHOT
FROM cdb_hist_snapshot
GROUP BY con_id, dbid, instance_number
ORDER BY 1,2,3;