Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Burned by DBMS_STATS **AGAIN**

RE: Burned by DBMS_STATS **AGAIN**

From: Wolfgang Breitling <>
Date: Tue, 08 Apr 2003 09:39:14 -0800
Message-ID: <>

the optimizer uses the following statistics:

dba_tables - blocks, num_rows, avg_row_len
dba_indexes - blevel, distinct_keys, leaf_blocks, avg_leaf_blocks_per_key, 
avg_data_blocks_per_key, clustering_factor
dba_tab_columns - num_distinct, low_value, high_value, density, num_nulls
dba_tab_histograms - endpoint_number, endpoint_value

At 07:34 AM 4/8/2003 -0800, you wrote:
>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
>does not include DEC RDB and Oracle Financials, Support can rummage through
>the 200 MetaLink articles that come back. :)

Wolfgang Breitling
Centrex Consulting Corporation

This email communication is intended as a private communication for the sole use of the primary addressee and those individuals listed for copies in the original message. The information contained in this email is private and confidential and if you are not an intended recipient you are hereby notified that copying, forwarding or other dissemination or distribution of this communication by any means is prohibited. If you are not specifically authorized to receive this email and if you believe that you received it in error please notify the original sender immediately. We honour similar requests relating to the privacy of email communications.

Cette communication par courrier electronique est une communication privee a l'usage exclusif du destinataire principal ainsi que des personnes dont les noms figurent en copie. Les renseignements contenus dans ce courriel sont confidentiels et si vous n'etes pas le destinataire prevu, vous etes avise, par les presentes que toute reproduction, tout transfert ou toute autre forme de diffusion de cette communication par quelque moyen que ce soit est interdit. Si vous n'etes pas specifiquement autorise a recevoir ce courriel ou si vous croyez l'avoir recu par erreur, veuillez en aviser l'expediteur original immediatement. Nous respectons les demandes similaires qui touchent la confidentialite des communications par courrier electronique.

Please see the official ORACLE-L FAQ:
Author: Wolfgang Breitling

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message
to: (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 Tue Apr 08 2003 - 12:39:14 CDT

Original text of this message