SQL & PL/SQL

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!

Better way to use DBMS_STATS.gather_table_stats to analyze table

762575Apr 8 2010 — edited Apr 12 2010

Hi,

I am using following script in oracle procedure to analyze the tables

DBMS_STATS.gather_table_stats (<instance_name>,
<table_name>,
estimate_percent => 5,
granularity => 'AUTO'
);

For some big tables, it is taking 30min to analyze with above script. I have tried degree => 16 with above script but did not help. So can any one help me to use the DBMS_STATS.gather_table_stats better way to analyze table? I am using Oracle 10.2 version.

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 10 2010

Added on Apr 8 2010

4 comments

1,035 views