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 [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > -----Original Message----- > From: Gurelei [mailto:[EMAIL PROTECTED] > 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).