Check statistics. I remember also a case when adding a 56th (or whereabout) partition to a table mysteriously changed the execution plan (not for the better, as you can guess, otherwise nobody would have noticed) in spite of statistics above all reproach.
Locking is another possibility. Also saw a case of automatic PGA management which set the sort_area_size to a value which caused (probably) memory alignment problems - which were easy to reproduce with manual PGA management.
Something MUST have changed, find first what it is. Then if you are lucky it's a mistake on your part. Otherwise you may have hit a bug.
Regards,
Stephane Faroult
On Fri, 4 Jun 2004 15:21 , 'Computer Centre - NIIPL' <compute@xxxxxxxxxxxxxxx> sent:
Dear All,
Every month we are running one process related to our Material Management
Systems. Approximately, it will take two to four hours to complete. But this
month we are not able to run the process even after 9 hrs.
What could be the problem?
How to go about it?
Thanks in Advance,
Balu.
This mail is scaned by eScan Anti Virus Software
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
