PRC: Update Project Performance Data program taking long time.
Hi Experts,
PRC: Update Project Performance Data program is running from long time from last 3-4 days and normally it takes 15mns but now it is taking hours and not completing.
I have there is no locking.
Insert statement is running behind this program and from explain plan I have found FULL TABLE SCAN on many tables and indexes.
Please help.
Regards,
OADBA
0