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!

How frequently should I analyze these Production Tables?

unknown-2973982Feb 24 2016 — edited Feb 27 2016

Hello All,

I hope this threads finds you all in good Spirits.

I have several tables in Production that are not being analyzed at all and the  developers are writing queries upon queries and then complaining about it being slow.

Here is what I am talking about.

Can you freaking BELIEVE THIS?!

I just did a query on dba_tables...

TABLE_NAME           NUM_ROWS LAST_ANALYZED

------------------------------ ---------- -------------

TABLE1                240703   05-FEB-16   
TABLE2                      5,490,323  20-FEB-16   
TABLE3                      723,449   23-FEB-16   
TABLE4           595,428   17-FEB-16   
TABLE5           371,590   19-FEB-16   
TABLE6                      590,251   24-JUL-13   
TABLE7                      2,358,154  31-JUL-13 

Now, based on the fact of the row counts, How often do I need to run dbms_stats.gather_table_stats on theses tables to help the CBO to make the best possible choice for it's execution plan?

Thanks,

Lady Allora...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 26 2016
Added on Feb 24 2016
#general-database-discussions
42 comments
7,484 views