Bind virtual processors to CPUs
You can use some multiprocessor systems to bind a process to a particular CPU. This feature is called processor affinity.
On multiprocessor computers for which the database server supports processor affinity, you can bind CPU virtual processors to specific CPUs in the computer. When you bind a CPU virtual processor to a CPU, the virtual processor runs exclusively on that CPU. This operation improves the performance of the virtual processor because it reduces the amount of switching between processes that the operating system must do. Binding CPU virtual processors to specific CPUs also enables you to isolate database work on specific processors on the computer, leaving the remaining processors free for other work. Only CPU virtual processors can be bound to CPUs.
For information about how to assign CPU virtual processors to hardware processors, see Processor affinity.