Re: Queries slower in 8.1.7.0 than in 8.1.6.2

Where is this hidden parameter. Is it in the init.ora or somewhere else ?

Tony
DMC Stratex Networks

"dias" <ydias_at_hotmail.com> wrote in message news:55a68b47.0202060221.7bba6c2e_at_posting.google.com...
> Hi,
>
> I found a solution to my probleme ... and I have now the same
> performance in 8.1.7 and 8.1.6 databases.
>
> The main diffrence between the two releases was the hidden parameter
> _or_expand_nvl_predicate
>
> In 8.1.7, the value is "TRUE". It was "FALSE" in 8.1.6.
>
> In my application, I have a lot of queries with " ... where nlv(...)"
> and with this parameter to TRUE, Oracle rewrite the queries.
>
> The Note:94064.1 on metalink explain the effect of this parameter
>
> Dias
>
>
> ydias_at_hotmail.com (dias) wrote in message
news:<55a68b47.0202010654.ce4fc87_at_posting.google.com>...
> > Hi,
> >
> > I've just upgrade a db from 8.1.6.2 to 8.1.7.0 on a Tru64 5.1a.
> > My application is a client-server one.
> >
> > All the queries run 3 or seconds slower.
> > With the explain plan, I've noticed that the optimizer uses more Hash
> > in the 8.1.7.0 version than in the 8.1.6.2.
> >
> > Every thing is the same between the two versions : init.ora, disks,
> > machine, RAM, ...
> >
> > Have I to apply the latest patch set to correct the problem.
> >
> > Thank you
Received on Wed Feb 06 2002 - 06:49:00 CST