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!

last analyzed "dba indexes" view not up to date

755353Nov 11 2011 — edited Nov 28 2011
Hi

Oracle decided not to collect stats on one large table ( last analyzed is 3 month out of date), this is huge table half a billion entry and thousand being added every day .

I understand that oracle gathers stats only if there are significant changes to the underlying table. I can’t do a select count on the table to see how much entry we have now ( select count(*) takes 7 hours to run)

My question is since stats are not up to date, will it cause any issues?
Will it case oracle to select wrong plan?
We do have performance problems and want to ensure this is not the cause
Thank you
This post has been answered by Mark D Powell on Nov 22 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 26 2011
Added on Nov 11 2011
23 comments
6,461 views