-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|