Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

dbms_stats.gather_schema_stats VS dbms_utility.analyze_schema

668860Apr 2 2009 — edited Apr 2 2009

hi folks,

I am trying to gather stats on Oracle 10.2.0.4 RAC on linux.

When I use - execute dbms_utility.analyze_schema('SYSADM','ESTIMATE',0,10); - stats are gathered in 3.5 hours

and whn I use - exec DBMS_STATS.gather_schema_stats(ownname=>'SYSADM',estimate_percent=>10, cascade=>TRUE, method_opt=>'FOR ALL COLUMNS SIZE AUTO',degree=>5);

this is taking 7-8 hours.

Oracle documentation says dbms_stats with PARALLEL option runs faster than the dbms_utility. please advise if I am missing anything here.

my goal is to gather stats as quickly as possible.

thanks!

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 30 2009

Added on Apr 2 2009

#general-database-discussions

5 comments

4,574 views