Skip to Main Content

Chinese

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!

单表做统计分析长时间未结束,怎么处理。

960966Sep 9 2012 — edited Sep 10 2012
DBMS_STATS.GATHER_TABLE_STATS('CC', 'ACCT333, DEGREE=>3, CASCADE=>TRUE,ESTIMATE_PERCENT=>10,no_invalidate => false);

数据库9I ,执行70分钟都没结束,怎么会这么长时间 ,是否有问题 该怎么处理? 表里面有3亿数据
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 8 2012
Added on Sep 9 2012
3 comments
494 views