How to prevent CPU's overloading while using Parallel Query
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