Re: Oracle 10g upgrade - performance issue
- From: Mladen Gogala <gogala@xxxxxxxxxxxxx>
- To: gorbyx@xxxxxxxxx
- Date: Wed, 12 Jul 2006 08:15:52 -0400
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
