Tim, I noticed that, but still it is a great article and I'm looking forward to reading the updated version
thanks for your help Gene --- Tim Gorman <[EMAIL PROTECTED]> wrote: > Please be aware that the paper and presentation were > written in the 8i > timeframe. I swear I'll get it updated for 9i, but > already 10G is looming > and it's summer and the weather is > nice........<sigh>... > > > > on 7/30/03 8:24 AM, Gurelei at [EMAIL PROTECTED] > wrote: > > > Rich, > > > > thanks a lot. I just finished reading Tim's paper > and > > it is truly enjoyable reading. I'm going to test > his > > advices in a few moments. > > > > Gene > > --- "Jesse, Rich" <[EMAIL PROTECTED]> wrote: > >> 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). > > > > > > __________________________________ > > 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: Tim Gorman > 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). __________________________________ 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: [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).
