how to limit oracle to use only 2 out of the 4 CPUs

Hi,

How would it be possible to limit an Oracle instance to use only 2 out of 4 CPUs.

Would it work by using DBMS_RESOURCE_MANAGER and set CPU_P1 => 50 ?

Thanks for any feedback

no resource manager wont do it, that just assigns 50% of the available cpu which oracle has to the session. It is only used when there is resource contention.

would it help to reduce the parameter CPU_COUNT to 2 ?

looking at the docs for cpu_cpunt it says never change this parameter

SO dunno