SQL Performance (MOSC)

MOSC Banner

purge history stats taking long time and very slow

edited Jul 23, 2015 10:03AM in SQL Performance (MOSC) 4 commentsAnswered

Hi All,

I'm trying purge history stats before doing upgrade of my 11.2.0.3 to 12c database, and it is taking a long time (more than 5 hours) to complete, any idea how to speed this up?

exec dbms_stats.alter_stats_history_retention(0);

set time on;

set echo on;

exec DBMS_STATS.PURGE_STATS(systimestamp);

Thanks!


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