Skip to Main Content

Oracle Database Free

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

AWR data not being purged as per retention setting

Simon_DBAFeb 23 2024 — edited Feb 23 2024

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;
Comments
Post Details
Added on Feb 23 2024
2 comments
160 views