The cynic in me would think that this is tantamount to Oracle asking us to beta-test their cbo-enabled dictionary in preparation for ver 10 :-)
I think they're pretty much there though - bucketloads of the recursive sql seems to be hinted nowadays, presumably to get it cbo ready. cheers connor --- Freeman Robert - IL <[EMAIL PROTECTED]> wrote: > There is actually now a comment in the 9iR2 doc's > that it's ok to start > generating stats on the SYSTEM tablespace (in prep > for the removal of RBO in > 10i). Has anyone actually done that in 9iR2, and > what is your experience? > > RF > > > -----Original Message----- > To: Multiple recipients of list ORACLE-L > Sent: 2/28/2003 2:23 PM > > > I remember it was noted here that > dbms_stats.gather_database_stats > was busted in 8i, it went about attacking system ts. > Is that fixed in > 9.2.0.2? > > > > > > > On Fri, Feb 28, 2003 at 11:16:17AM -0800, DENNIS > WILLIAMS wrote: > > Chuck - Don't do it man! People have had very bad > problems due to > this. > > > > Dennis Williams > > DBA, 40%OCP, 100% DBA > > Lifetouch, Inc. > > [EMAIL PROTECTED] > > > > > > -----Original Message----- > > Sent: Friday, February 28, 2003 11:09 AM > > To: Multiple recipients of list ORACLE-L > > > > > > What's the current recommendation for gathering > statistics on system > schema > > objects like SYS, and OUTLN? Are they still saying > not to do it? I am > on > > 8.1.7. > > > > > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > > -- > > Author: Chuck Hamilton > > 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: DENNIS WILLIAMS > > 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). > > -- > =============================================================== > Ray Stell [EMAIL PROTECTED] (540) 231-4109 > KE4TJC 28^D > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Ray Stell > 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). > ===== 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" __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.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).
