Oracle-L: Re: dbms_stats broken

From: Kirtikumar Deshpande <kirtikumar_deshpande_at_yahoo.com>
Date: Wed, 28 May 2003 20:34:40 -0800
Message-ID: <F001.005A52C7.20030528203440@fatcity.com>

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" <Lisa.Koivu_at_Fairfieldresorts.com> 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: kirtikumar_deshpande_at_yahoo.com

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: ListGuru_at_fatcity.com (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).

Received on Wed May 28 2003 - 23:34:40 CDT