Skip to Main Content
  • Questions

  • Using resource manager group to restrict DOP

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, GOPAL.

Asked: March 27, 2018 - 12:29 pm UTC

Last updated: March 28, 2018 - 10:20 am UTC

Version: 11g

Viewed 1000+ times

You Asked

Hi,

We are planning to user Oracle Resource Manager Group to restrict DOP(degree of parallelism) to some fixed number in our database. We have around 10 schemas and we need to restrict DOP in those schemas. There is definitely benefit by using the resource manager i.e. we can restrict the DOP. Do you find any issues/problems with this?

Thanks.

Regards;
Gopal

and Chris said...

The Database Resource Manager is designed to let you set different limits for users/apps for things such as the parallel limit.

So: no! ;)

In fact, as Yasin Baskan (Parallel PM) says:

we recommend leaving [PARALLEL_DEGREE_LIMIT] as default and using Database Resource Manager (DBRM) to limit the DOP

And you may want to look at using these alongside auto DOP, which tunes the degree of parallel for statements automagically.

You can read more about this at:

https://blogs.oracle.com/datawarehousing/what-is-auto-dop
https://blogs.oracle.com/datawarehousing/configuring-and-controlling-auto-dop

Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Performance

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