How to prevent CPU's overloading while using Parallel Query

[amasny]

Hi,

I have short question :

I would like to implement PQ on select using hint : /*+ parallel(alias,DOP) */
How to prevent cpu’s from overloading using DOP parameter ?
Use more or less DOP ?

I would like to use DOP for this task because it is simplest way in my opinion.
I know about resource manager but it requires some time and testing to implement.

We have two separate databases ran on computer with 8 CPU’s, so using parameter : parallel_adaptive_multi_user won’t be good solution, I think.

------------------------------------------------
Regarding using resource manager : How to implement directive for some group : NOT to using first CPU at all and use other CPU's left in machine ?


Best Regards
Arek Masny