Yes starting from db version 8.1.7 for 11i. For 8.1.6 there was no such requirement IIRC. I tried to be smart and ignored the recommendation once when upgrading to 8.1.7 - the result, some queries which were using a view (which name I don't remember anymore) got extremely slow. I learned a lesson.
Tanel. ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, August 26, 2003 8:54 PM > Just fyi - it seems that Oracle had realized this in advance and has > specifically instructed the Oracle Applications 11i installations to set > this to 2000. > > John Kanagaraj > DB Soft Inc > Phone: 408-970-7002 (W) > > Listen to great, commercial-free christian music 24x7x365 at > http://www.klove.com > > ** The opinions and facts contained in this message are entirely mine and do > not reflect those of my employer or customers ** > > -----Original Message----- > Sent: Tuesday, August 26, 2003 8:55 AM > To: Multiple recipients of list ORACLE-L > > > One thing that the docs don't mention is that '80000' > (the default in 8) is also a special boundary value. > Anything less than 80,000 changes some of ways the > optimizer does it work, ie, its not just a reduction > in permutations. > > Can't remember the specifics - join orders spring to > mind but there is a metalink note about it. > > Because of this, there's a school of thought that even > on 8i, adopting the (9i default) value of 2000 will > improve the "general" optimizer performance (ie the > quality of the decisions it makes). > > Cheers > Connor > > --- "Boivin, Patrice J" <[EMAIL PROTECTED]> > wrote: > Has anyone worked with this one? > > > > > http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76961/ch11 > > 23.htm#81357 > > > <http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76961/ch1 > > 123.htm#81357> > > > > Patrice. > > > > ===== > Connor McDonald > web: http://www.oracledba.co.uk > web: http://www.oaktable.net > email: [EMAIL PROTECTED] > > "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, > and...he will sit in a boat and drink beer all day" > > ________________________________________________________________________ > Want to chat instantly with your online friends? Get the FREE Yahoo! > Messenger http://uk.messenger.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: =?iso-8859-1?q?Connor=20McDonald?= > 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: John Kanagaraj > 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: Tanel Poder 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).
