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!

dbms_stats vs analyze table

ccstaJun 1 2016 — edited Jun 1 2016

We had a report performance issue. We ran 'dbms_stats.gather_database_stats' but it did not improve any performance (still took >1 hr). Then we ran 'analyze table compute statistics' and fixed the problem (took 1 min). Can someone explain why the results are so different? Was 'analyze' command already replaced by 'dbms_stats' since 10g? We are on 12c.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 29 2016
Added on Jun 1 2016
10 comments
1,624 views