For right now, I am unable to comment on anything 10g. Thanks for understanding!
Robert -----Original Message----- To: Multiple recipients of list ORACLE-L Sent: 10/7/2003 3:44 PM Nope. Mr Freeman are you out there?? Also, Jonathan Lewis is a commentary author for this book, so he may some insight. But wait, I have some dice at my desk...bingo...it's 8 percent faster. You can quote me. -----Original Message----- [EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 4:04 PM To: Multiple recipients of list ORACLE-L did he mention any benchmarked performance improvements from gathering statistics on the system tablespacE? > > From: "Grabowy, Chris" <[EMAIL PROTECTED]> > Date: 2003/10/07 Tue PM 03:34:25 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: Desupport of RBO > > At the recent NYOUG conference, they were handing out special preview copies of Oracle 10g New Features by our very own Robert Freeman.... > > Page 11 has a section entitled...Collecting Data Dictionary Statistics...this is done using the DBMS_STATS.GATHER_DICTIONARY_STATS procedure. > > Does that answer your question Patrice? > > -----Original Message----- > Sent: Tuesday, October 07, 2003 3:00 PM > To: Multiple recipients of list ORACLE-L > > > We had issues here with first_rows and all_rows when set in init.ora for 8i a couple of years ago... performance dropped significantly. During discussions with Oracle Support I learned that the data dictionary for 8i has to run in rule mode, I don't know if they changed that in 9i or 10G. > > Hopefully... 10G still has a data dictionary I imagine. > > : ) > > Patrice. > > -----Original Message----- > Sent: Tuesday, October 07, 2003 3:14 PM > To: Multiple recipients of list ORACLE-L > > > > 10g it won't be supported... wander when rule hints won't be used in E-Business Suite... 11.5.8 still has rule hints in some of the code. > > April Wells > Oracle DBA/Oracle Apps DBA > Corporate Systems > Amarillo Texas > /\ > / \ > / \ > \ / > \/ > >\< > \ > >\< > \ > Few people really enjoy the simple pleasure of flying a kite > Adam Wells age 11 > > > > -----Original Message----- > Sent: Tuesday, October 07, 2003 1:05 PM > To: Multiple recipients of list ORACLE-L > > > OK, dumb question. Does this mean the rule hint won't be possible? > Application I support mostly uses CBO but there have been cases where we had to > resort to RBO hint. 'course it'll be some time before we can consider v10... > > Kip > > |Hi Jared, > > |haven't seen it, too. But the fact > |was spreaded over the newsgroups. > > |We still have some 3rd party apps that don't use > |*any* feature above Oracle 7 (well, almost). Queries with > |the RULE hint where it's not necessary. > |But if we change a thing, support will be lost. > |So we decided to rewrite the whole app. > |Lucky me: enough work for the next years. > > |Greetings, > |Guido > > |>>> [EMAIL PROTECTED] 07.10.2003 01.34 Uhr >>> > |First time I've seen this note: 189702.1 > > |Jared > > |-- > |Please see the official ORACLE-L FAQ: http://www.orafaq.net > |-- > |Author: Guido Konsolke > | 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: > 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). > > > The information contained in this communication, including attachments, is strictly > > confidential and for the intended use of the addressee only; it may also contain > > proprietary, price sensitive, or legally privileged information. Notice is hereby given that > > any disclosure, distribution, dissemination, use, or copying of the information by anyone > > other than the intended recipient is strictly prohibited and may be illegal. If you have > > received this communication in error, please notify the sender immediately by reply e-mail, > > delete this communication, and destroy all copies. > > > > > > Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to > > this e-mail has been swept for viruses. We specifically disclaim all liability and will > > accept no responsibility for any damage sustained as a result of software viruses and advise > > you to carry out your own virus checks before opening any attachment. > > > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grabowy, Chris 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: Freeman Robert - IL 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).