RE: Issues with queries after upgrade,

Do you have the same init.ora parameters in dev, test and production (all
9.2.0.4), such as sort_area_size?

I also found the 9i's explain plan is different from 8i's for some of our
queries. This must be due to the optimizer changes (or some not-so-visible
default parameters changes) that Oracle puts in 9i. The only way to find
them is to thoroughly test all your queries in 9i before moving into
production.

Guang

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Fuad Arshad
Sent: Wednesday, June 30, 2004 11:08 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Issues with queries after upgrade,


We've upgraded to 9.2.0.4 on one of our high volume databases. As usual
everything was fine in dev and test but high volume queries have started to
break   .
one of the problems that we founf the the unnest_subq turned off.
finally to try to fix things i set the optimizer_features_enable=8.1.7
but  some of our explain plans have changed wherein the query was using a
sort is not now using concatenation.
any ideas thoughts on why this is happening.
strangely enough if  i run some of the queires using optimizer_goal=rule
they do run very fast. and have a better explain plan.


----------------------------------------------------------------
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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: