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?
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Fri Sep 09 2005 - 17:52:24 CDT
