Re: CBO influences

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 9 Sep 2005 19:44:59 +0000 (UTC)
Message-ID: <dfsonr$5g9$1@nwrdmz03.dmz.ncs.ea.ibs-infra.bt.com>

"EdStevens" <quetico_man_at_yahoo.com> wrote in message news:1126294364.813025.287860_at_o13g2000cwo.googlegroups.com...
> Bingo! My partner had assured me that he had checked the
> initialization parms and they were all identical. When I looked at the
> 10053 trace where all the optimizer related parms were grouped together
> I discovered that OPTIMIZER_INDEX_CACHING, OPTIMIZER_INDEX_COST_ADJ,
> and OPTIMIZER_MAX_PERMUTATIONS were different.
>

There's a nice little feature in 10g
that helps with that, the parameter
list is split into the parameters
with altered values and parameters
with default values.

Such a small change, but such a
big help.

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
Cost Based Oracle - Volume 1: Fundamentals
On-shelf date: Nov 2005

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/appearances.html
Public Appearances - schedule updated 4th Sept 2005

Received on Fri Sep 09 2005 - 14:44:59 CDT