Database Tuning (MOSC)

MOSC Banner

AWR auto purge not working after 12.1.0.2 db upgrade

edited Dec 22, 2015 8:47AM in Database Tuning (MOSC) 14 commentsAnswered ✓

The AWR auto purge is not working after upgrading from 11.2.0.3 to 12.1.0.2.  This is a relatively small standalone test database using ASM (also 12.1.0.2).  I upgraded the database to 12.1.0.2 on 24 Nov, and the retention policy shows as 8 days, but I still have old snapshots, even those from 11.2.0.3.  I am running dbms_workload_repository.drop_snapshot_range to remove the old 11.2.0.3 snapshots, but that will still leave more than 8 days of snapshots in the database.  How do I check on the "health" of the 12.1.0.2 AWR auto purge?  I searched Oracle Support and MOSC but have not found anything

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center