Jump to content
Esu X

Oracle statistics gathering - stale_percent and concurrent testing

Recommended Posts

Hello... 

I want to change "stale_percent" to 3 and "concurrent" to true, but I need to test it first. I need to improve statistics gathering on very large fast changing tables.

What is the best way to check before and after it will be set to check if this make any difference?

I read that I need to check parameter JOB_QUEUE_PROCESSES and parallel_adaptive_multi_user before I will set "concurrent".

Could you advise what values are save when setting it?

Thank you in advance.

Share this post


Link to post
Share on other sites

Hi Esu, and welcome to the forum!

Except for very volatile data, a single dbms_stats is enough.

Remember, the ONLY reason to re-analyze stats is to change execution plans. A risky thing to do in a production database.

Please read carefully:

http://www.dba-oracle.com/oracle_tips_re_analyze.htm

If it ain’t broke, don’t fix it!

Hope this helps . . . 

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

×