Thanks for the question, Rajiv.
Asked: April 17, 2018 - 10:05 am UTC
Last updated: April 18, 2018 - 2:17 am UTC
Version: 11g
Viewed 1000+ times
You Asked
I am setting the degree parameter of dbms_stats.gather_table_stat. could any one tell me that how we can calculate the value of this parameter and how this is link with the hint optimize techniques.
and Connor said...
DEGREE is equivalent to running the core queries that gather the statistics in parallel.
What is "best" can only be answered by you.
For example, if you have an 8core server, then a degree of 8 or 16 might give optimal results...BUT...that also means that gathering the stats may consume almost *all* of the available resources, and thus impact other users on the system.
DEGREE is a means of finding a balance between
- the time it takes to gather stats,
- the impact of gathering those stats on other users of the database
- the value of regularly updated statistics. (for example, if you a gathering every night, maybe a less frequent setting is just as good).
Only you can know the right balance for your business requirements.
Is this answer out of date? If it is, please let us know via a Comment