Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!sn-xit-04!sn-xit-12!sn-xit-09!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: DA Morgan Newsgroups: comp.databases.oracle.server Subject: Re: CBO influences Date: Fri, 09 Sep 2005 15:52:24 -0700 Organization: Ye 'Ol Disorganized NNTPCache groupie Message-ID: <1126306293.634107@yasure> User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 References: <1126283179.991124.138480@z14g2000cwz.googlegroups.com> <1126284892.947680.217710@g44g2000cwa.googlegroups.com> <1126294364.813025.287860@o13g2000cwo.googlegroups.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cache-Post-Path: yasure!unknown@oracle.advtechserv.com X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 27 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251215 Jonathan Lewis wrote: > "EdStevens" wrote in message > news:1126294364.813025.287860@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@x.washington.edu (replace x with u to respond)