Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Purge Stats History taking too long

JimboApr 25 2012 — edited Sep 12 2012
Hi,

I am doing a purge of stats history on my database and it is taking ages for what I believe should be a small data set

I have checked the stats history retention using

select dbms_stats.get_stats_history_availability from dual;
26/11/2010 22:10:42.668499000 +00:00

select sysdate-500
from dual;
12/12/2010 10:52:09

exec dbms_stats.purge_stats(sysdate-500);

The above purge has been running for over an hour ( and is still going ! ). This is on a test system with no real other activity going on within it.

Q1. Why is the above purge taking so long on what should be a relatively small data set ?

any help greatly appreciated,
Jim
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 10 2012
Added on Apr 25 2012
9 comments
5,067 views