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).
