Re: Oracle 10g upgrade - performance issue

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Wed, 12 Jul 2006 08:15:52 -0400
Message-Id: <1152706552l.2743l.0l@medo.noip.com>

On 07/12/2006 05:02:04 AM, Alex Gorbachev wrote:

> And this is called "upgraded smoothly"? ;-)

With new versions, there is no such thing as a "smooth upgrade". CBO is the principal culprit.

> There is no silver bullet and as Allen mentioned "Method R" might be
> your friend but you need some time to get into it and actually some
> time to use it. But its results would be most probably the best. ;-)

Actually, there is a bullet with a rather high percentage of silver: setting optimizer_index_* & first_rows_n parameters. That will get you session wide emulation of RBO. As for the system statistics, running 10g without it is a felony. They should make a constitutional amendment baning that.

-- 
Mladen Gogala
http://www.mgogala.com

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jul 12 2006 - 07:15:52 CDT