Thanks, Terry.
That reminded me to review Wolfgang Breitling's "What is New in the oracle
9i CBO".
I'm setting one-by-one the parameters that changed defaults between 8i and
9.2 at the session level.
I haven't hit the correct one yet, but you've given me hope!
Barb
On 11/4/05, Terry Sutton <terrysutton_at_usa.net> wrote:
>
> Barbara,
> I can't tell you the specific action to take to fix the process, but it's
> root cause is probably because of the different default values in 9i vs. 8i
> for many underscore parameters related to the optimizer. These particularly
> affect subqueries. Take a look in Metalink for terms like "unnest".
> --Terry
>
> I'm testing an upgrade of a database from version 8.1.7.4 <http://8.1.7.4>to version
> 9.2.0.4 <http://9.2.0.4>
> Test db LEGS Oracle version 9.2.0.4 <http://9.2.0.4> just created
> Prod db ARMS Oracle version 8.1.7.4 <http://8.1.7.4>
> Prod db AMPROD Oracle version 9.2.0.4 <http://9.2.0.4>
>
>
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Nov 04 2005 - 15:23:20 CST
