Re: CBO influences

"DA Morgan" <damorgan_at_psoug.org> wrote in message news:1126306293.634107_at_yasure...
> Jonathan Lewis wrote:
>> "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.
>
> Didn't the ISDEFAULT column exist in previous versions?

Indeed,

But we are talking about the 10053 trace file, and the current values for your session's parameters may not match the environment under which the trace was generated.

-- 
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