Re: materialized view via link slow after upgrade from 8i to 9i
- From: Barbara Baker <barb.baker@xxxxxxxxx>
- To: terrysutton@xxxxxxx
- Date: Fri, 4 Nov 2005 14:21:08 -0700
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@xxxxxxx> 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>
>
>
Other related posts:
