Hello
There is a clone script that runs each morning and it normally takes a couple of hours and is now taking 5 - 6 hours.
I think I have nailed the culprit down to the following command:
DBMS_STATS.PURGE_STATS(NULL);
The actual script does the following:
exec DBMS_STATS.ALTER_STATS_HISTORY_RETENTION(7) /// the source system has retention of 10 days
/
exec DBMS_STATS.PURGE_STATS(NULL) /// I believe this is hanging.
/
I see no errors in the DB and just wanted to reach out to the experts here to see if I should be checking something obvious.
Thanks.
11.2.0.2
RHEL 5.2
(EBS 11.5.10.2)