Hello Lisa Monkey, What platform are you jumping up on? Do you have tables with lots of branches.. er.. partitions?
I have been using dbms_stats to collect stale stats on HP-UX 11.0 with a 8.1.7.4 database. These are not partitioned tables. All are being 'monitored', the script to collect stale stats runs every morning as some tables are truncated and reloaded, while others are modified. I get a report of all tables that were found to have 'stale' stats and got analyzed. Here is my today's report : (HRWT is the database, HRW is the schema) df2hptest [HRWT]: more gather_stale_stats_HRWT_HRW.log Connected. Owner HRW : TABLE -> "ATH_EMPLOYEE" Owner HRW : TABLE -> "CTLR_KEYERS" Owner HRW : TABLE -> "CUR_EMPLOYEES" Owner HRW : TABLE -> "EMERGENCY_CONTACTS" Owner HRW : TABLE -> "EXT_BA_EMPLOYEES" Owner HRW : TABLE -> "EXT_GTE_EMPLOYEES" Owner HRW : TABLE -> "LKP_EMPL_NAME" Owner HRW : TABLE -> "MSS_APPLICATION_DIR" Can you please post the Metalink reference about the problem with DBMS_STATS in 8.1.7.4? I know that the global stats (histograms) for partitioned tables is an issue, but would like to know of other problems as well. Thanks. - Kirti --- "Koivu, Lisa" <[EMAIL PROTECTED]> wrote: > Hello everyone, > > Is anyone using dbms_stats and gather stale or gather auto in 9.2? I'm > trying to use dbms_stats gather schema stats with the stale option and > it just isn't working in 8.1.7.4. This is documented on Metalink. I'd > love to hear from someone else if this is fixed in 9.2 and if it can be > reliably used. > > Thank you > Lisa Monkey. > > > __________________________________ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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).