This content has been marked as final. Show 2 replies
Unless you have the need to keep AWR snapshot data more than a few days, I would run schedule the PURGE_STATS procedure to run daily. The biggest problem with not doing it, as you have seen, is a growing for full SYSAUX tablespace that cannot be shrunk.1 person found this helpful
I have modified the retention of old stats to 7 days and purged the stats older than 7 days.I think it will reduce the growth by 50%.
exec dbms_workload_repository.modify_snapshot_settings (retention =>10080);