Performance of DBMS_STATS vs ANALYZE

From: Charlotte Hammond <charlottejanehammond_at_yahoo.com>
Date: Wed, 19 May 2004 10:18:54 -0700 (PDT)
Message-ID: <20040519171854.96138.qmail@web20729.mail.yahoo.com>

Hi All,

Could I ask people's experience with DBMS_STATS with regard to performance.

When I run this:

DBMS_STATS.GATHER_SCHEMA_STATS(

      OWNNAME=>'myschema',
      ESTIMATE_PERCENT=>'<<n>>',
      CASCADE=>TRUE);

It is anywhere between 3 and 4 times slower than a script containing

ANALYZE TABLE myschema.<table> ESTIMATE STATISTICS SAMPLE <<n>> PERCENT FOR TABLE FOR ALL INDEXES; for all the tables in my schema. There are approx. 1000 tables, many of which are empty.

I have tried this on 9.2.0.4 and 9.2.0.5 with similar results.

Is this typical?

Thanks

Charlotte

Do you Yahoo!?
SBC Yahoo! - Internet access at a great low price.

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 May 19 2004 - 12:16:10 CDT