Yes. At least I was before reverting back to ANALYZE. For our little 30GB DB, there's little penalty for non-parallel stats gathering on Saturdays. Then again, one could ANALYZE multiple tables at once to regain some parallelism in stats gathering...
Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -----Original Message----- Sent: Wednesday, December 03, 2003 10:19 PM To: Multiple recipients of list ORACLE-L Rich, I went thru the archives. Are you using the option 'cascade=>true' for gather_table_stats? -----Original Message----- Jesse, Rich Sent: Wednesday, December 03, 2003 4:21 PM To: Multiple recipients of list ORACLE-L Yes -- same platform and version. If you look on the list archives (fatcity.com, for example) for a subject of "Burned by DBMS_STATS **AGAIN**" back in April 2003, you may get some insight. There are also known bugs in GATHER_SCHEMA_STATS in 8i. The recommendation is to iteratively call GATHER_TABLE_STATS. GL! Rich -- 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).
