For the ignorant, what is 10G? v/r
Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 > -----Original Message----- > From: Tim Gorman [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 30, 2003 12:30 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: optimizer parameters in Oracle 9.2 > > > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfe Stephen S GS-11 6 MDSS/SGSI 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).