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).

Reply via email to