Re: The optimizer makes me *desperate*...

From: Nuno Souto <nsouto_at_optushome.com.au>
Date: 30 Jan 2003 19:34:57 -0800
Message-ID: <dd5cc559.0301301934.6cad3be5@posting.google.com>

"Richard Foote" <richard.foote_at_bigpond.com> wrote in message news:<N39_9.36729$jM5.93185_at_newsfeeds.bigpond.com>...

Don't forget this!:

> > We had a DB on an NT server, in 8.0.6. I've just migrated
> > it to 8.1.7.1 on Sun/Solaris. Since then, the users do not
> > cease from complaining about the slowlyness of the app etc
> > etc.

> "Classic" reasons for Oracle not using an index when it's sitting there
> lonely and looking for action include:
>snip of very useful stuff...

The most obvious one: he's using 8.1.7.1 There are about dozen or so CBO patches after that, making up the patchset 8.1.7.4

Best if he considers patching up to 8.1.7.4 before spending anytime in elaborate tuning, no?

IME, that patchset level solved just about all the issues I had with the CBO...

Cheers
Nuno Souto
nsouto_at_optusnet.com.au.nospam Received on Thu Jan 30 2003 - 21:34:57 CST