Editorial question39.7K views4,795 votes0 answers1,773 following
AI-generatedAWR Snapshot Retention: Missing Automatic Space‑Based Purge Trigger for SYSAUX
Goal: Configure Oracle AWR to automatically purge the oldest snapshots when the SYSAUX tablespace free space falls below a defined threshold, ensuring continuous snapshot collection without manual intervention. Currently, AWR retention is governed solely by a time‑based interval set through DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS; Oracle does not m