| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Fuad Arshad
Sent: Wednesday, June 30, 2004 11:08 AM
To: oracle-l_at_freelists.org
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.
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlReceived on Wed Jun 30 2004 - 10:23:31 CDT
-----------------------------------------------------------------
 |
 |