Re: optimizer parameters in Oracle 9.2

See http://www.evdbt.com/SearchIntelligenceCBO.doc

Hemant
At 06:04 AM 30-07-03 -0800, you wrote:
>Hi all:
>
>I have been reading on the optimizer_ parameters for
>Oracle 9i - optimizer_max_permutation,
>optimizer_index_caching and optimizer_index_cost_adj.
>I have also been playing whith them and I can see that
>they affect the explain plans for some queries quite
>dramatically. Is there any guidelines for what they
>should be set to for optimum performance (some kind of
>range and may be relationship between the values) or
>is this mostly a trial and error kind of thing? I have
>seen a few discussion on the Oracle Metalink, but
>mostly they are very specific - try this value or try
>that value. Does anyone have a link to a document with
>something more systematic than that?
>
>
>thank you
>
>Gene
>
>__________________________________
>Do you Yahoo!?
>Yahoo! SiteBuilder - Free, easy-to-use web site design software
>http://sitebuilder.yahoo.com
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Gurelei
> INET: gurelei_at_yahoo.com
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hemant K Chitale
  INET: hkchital_at_singnet.com.sg

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).