Skip to Main Content
Forums

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!

what happens when I run dbms_stats.gather_table_stats

steinerJun 4 2015 — edited Jun 4 2015

Hi,

If I run dbms_stats.gather_table_stats, will the existing stats remain until the new stats have been fully compiled?

If I ran a query while gathering stats, will the old stats be available for the optimizer or will I just get a full table scan?

running 11.2.0.3

Thanks

Randy
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 2 2015
Added on Jun 4 2015
#general-database-discussions
5 comments
856 views