RE: Burned by DBMS_STATS **AGAIN**

Jonathan/Wolfgang,

I know there were differences in the number of rows in DBA_TAB_HISTOGRAMS for that schema between DBMS_STATS and ANALYZE. I've captured the ANALYZEd rows, wiped them and am now re-DBMS_STATing the schema table by table to avoid some bugs in GATHER_SCHEMA_STATS. I'll report my comparison as soon as it's done.

What is a good way to compare statistics between the two methods? I'll be comparing the contents of DBA_TAB_HISTOGRAMS, but what columns in DBA_TABLES/DBA_INDEXES or other views should I be capturing for comparison?

I've also opened a TAR on this. Until MetaLink knows that "ALL MY PRODUCTS" does not include DEC RDB and Oracle Financials, Support can rummage through the 200 MetaLink articles that come back. :)

Thx!
Rich

Rich Jesse                        System/Database Administrator
rich.jesse_at_qtiworld.com           Quad/Tech International, Sussex, WI USA

-----Original Message-----
Sent: Monday, April 07, 2003 4:39 PM
To: Multiple recipients of list ORACLE-L

I agree.

I wonder if some of the problems are to do with changes in the number of bytes used for storing details of character columns ? I don't recall which version the big change took place.

Regards

Jonathan Lewis

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: 07 April 2003 22:19

> What are the differences in the statistics between analyzed and
> "dbms_statsed" ?
> AFAIK an analyze collects size 1 histograms (lo and high values) for
all
> columns, so it should be equivalent to "for all columns size 1".
> The table is not by any chance partitioned?
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.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).