Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!newsfeed.cwix.com!newsfeed.icl.net!newsfeed.fjserv.net!diablo.theplanet.net!newspeer1-gui.server.ntli.net!ntli.net!news2.euro.net!newshub1.home.nl!home.nl!not-for-mail
From: Frank <fvanbortel@netscape.net>
Newsgroups: comp.databases.oracle.server
Subject: Re: optimizer parameters
Date: Fri, 10 Oct 2003 13:36:31 +0200
Organization: @Home Benelux
Lines: 25
Message-ID: <bm656k$p6i$1@news1.tilbu1.nb.home.nl>
References: <3F82E81E.98A92384@wholefoods.com> <1065548207.610779@yasure> <3F830A7F.56AE6A57@wholefoods.com> <cf90fb89.0310071622.a831aeb@posting.google.com>
NNTP-Posting-Host: cc28855-a.hnglo1.ov.home.nl
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Trace: news1.tilbu1.nb.home.nl 1065785364 25810 217.121.193.81 (10 Oct 2003 11:29:24 GMT)
X-Complaints-To: abuse@home.nl
NNTP-Posting-Date: Fri, 10 Oct 2003 11:29:24 +0000 (UTC)
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax)
X-Accept-Language: en-us, en
In-Reply-To: <cf90fb89.0310071622.a831aeb@posting.google.com>
Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:244987

Geomancer wrote:

<snip>

> 
> From OTN, good advice:
> 
> Rarely change CBO parameters. The CBO parameters are very dangerous
> because a single parameter change could adversely affect the
> performance of an entire enterprise. Changes to critical CBO
> parameters such as optimizer_mode, optimizer_index_cost_adj, and
> optimizer_index_caching should only be made after careful system
> testing.
> 
> http://otn.oracle.com/oramag/webcolumns/2003/techarticles/burleson_cbo_pt1_pt2.html
Humbug! Apart from the "should be tested" bit.

Changing any parameter could cause the enterprise performance to change.
Want another open door to kick in?!?

Remember the default shared pool of 3.5 MB? Suppose you never changed
that, did you - come on!
-- 
Regards, Frank van Bortel