Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: DBMS_STATS [resend chomped version]

RE: DBMS_STATS [resend chomped version]

From: Barbara Baker <barbarabbaker_at_yahoo.com>
Date: Wed, 16 Jun 2004 15:12:06 -0700 (PDT)
Message-ID: <20040616221206.87761.qmail@web50605.mail.yahoo.com>


Regarding #1:
(9.2.0.4 Solaris 9)
We have a recommendation from the sw vendor to compute with histograms using

exec dbms_stats.gather_schema_stats(ownname => 'SCOTT', estimate_percent =>
dbms_stats.auto_sample_size, method_opt => 'for all columns size skewonly', cascade => true);

as an initial method to gather the stats. I did a bit of looking and a bit of testing, and it looks good to me. Down side: it did take several hours to gather the initial set of stats.

What are other folks doing with histograms??

Barb


Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Wed Jun 16 2004 - 17:08:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US