Re: Queries slower in 8.1.7.0 than in 8.1.6.2

Thanks Jonathan and Nathan,

Jonathan, I've just started reading your book last week.

"c'est un super bouquin"

Before writing to this newsgroup, I have tried some solutions.

I changed the parameters compatible and optimizer_features_enabled to the same values in the 8.1.6.2 version and to new values 8.1.7. I've also applied the patch 8.1.7.2.

But these changes did not improve anything.

I'll examin the changes in the hidden parameters, and I hope I'll find a solution.

Thank you

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:<1012602552.9330.0.nnrp-02.9e984b29_at_news.demon.co.uk>...
> Do you have a (collection of) bug number(s) ?
>
>
> --
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
> Now running 3-day intensive seminars
> http://www.jlcomp.demon.co.uk/seminar.html
>
> Host to The Co-Operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
> Author of:
> Practical Oracle 8i: Building Efficient Databases
>
>
> Nathan Carney wrote in message ...
> >Dias
> >
> >Oracle has admitted a performance issue in 8.1.7.0.
> >
> >This is supposedly fixed from 8.1.7.2 but in our case we had to wait until
> >8.1.7.3.0 as 8.1.7.2.0 occasionally core dumped( another known bug).
> >
Received on Sat Feb 02 2002 - 11:18:32 CST