cpuaffinityset conflicts with another pool's reservation

phil2

Hello.

I'm trying to set exclusive cpu affinity for loader pool and I cannot do this:

`
alter resource pool mypool cpuaffinitymode EXCLUSIVE cpuaffinityset '88-95'
-- Message: Request for reservation of CPU #88 conflicts with another pool's reservation,
-- Sqlstate: 22023,

alter resource pool mypool cpuaffinitymode EXCLUSIVE cpuaffinityset '10%'
-- Message: Unable to allocate 10 CPUs for resource pool in EXCLUSIVE affinity mode,
-- Sqlstate: 22023,
`

I see that for an empty test cluster there is no problem with enforcing exclusive affinity.
What are the limitations for setting cpu affinity? I'm geussing I need to close all sessions before doing it.

SruthiA

Please open a support case and share scrutinize. we need to review what is going on in the cluster to share suggestions.