Skip to Main Content

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!

gather table stats takes time for big table

lm422407shFeb 12 2011 — edited Feb 12 2011
Table has got millions of record and it is partitioned. when i analyze the table using the following syntax it takes more than 5 hrs and it has got one index.

I tried with auto sample size and also by changing the estimate percentage value like 20, 50 70 etc. But the time is almost same.

exec dbms_stats.gather_table_stats(ownname=>'SYSADM',tabname=>'TEST',granularity =>'ALL',ESTIMATE_PERCENT=>100,cascade=>TRUE);

What i should do to reduce the analyze time for Big tables. Can anyone help me. l
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 12 2011
Added on Feb 12 2011
5 comments
5,585 views