Jump to content
JCRowan

Gather Stats Full Schema vs Stale Stats

Recommended Posts

Hello,

 

I have a question for you all. We are on 12.1.0.2 - automatic stats gathering not being taken into consideration here.

If I have gathered statistics for an entire schema(initially), then only gather statistics for the tables that go stale, is that considered best practices?

Is this a true statement - If you have gathered the statistics on a table and it never goes stale - are those statistics still accurate?

 

Thanks,

JC

 

 

Share this post


Link to post
Share on other sites

Hi JC, and welcome to the forum!

 

You ask a great question!

 

Remember, the only reason to gather cBO stats is to change sql execution plans!

 

In many systems, there exists only one optimal plan, and you don't ever want to change it!

 

Anyway, I only reanalyze when I see suboptimal plans, but it depends on the database volatility:

 

Please read:

 

http://www.dba-oracle.com/t_statistics_opt...y_reanalyze.htm

 

This link is also useful:

 

http://www.praetoriate.com/t_op_sql_gathering.htm

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×