Search the Community
Showing results for tags 'oracle database'.
Found 1 result
Esu X posted a topic in Oracle ForumHello... 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.