Re: Oracle 10g upgrade - performance issue

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

Other related posts: