Skip to Main Content

Breadcrumb

May 4th

Question and Answer

Connor McDonald

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

More to Explore

Performance

Get all the information about database performance in the Database Performance guide.