RE: optimizer parameters in Oracle 9.2

Paging Mr. Gorman....Mr. Tim Gorman...

I had wonderful luck with Tim's paper "The Search for Intelligent Life in the Cost-Based Optimizer" from:
http://www.evdbt.com/papers.htm

Enjoy! (And thanks again, Tim!)

Rich

Rich Jesse                           System/Database Administrator
rjesse_at_qtiworld.com                  Quad/Tech Inc, Sussex, WI USA

> -----Original Message-----
> From: Gurelei [mailto:gurelei_at_yahoo.com]
> Sent: Wednesday, July 30, 2003 9:04 AM
> To: Multiple recipients of list ORACLE-L
> Subject: optimizer parameters in Oracle 9.2
>
>
> 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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.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).