Configure the system to use more CPUs to improve performance. Multiple CPUs allow the system to run multiple sessions in parallel as well as multiple pipeline partitions in parallel.
However, additional CPUs might cause disk bottlenecks. To prevent disk bottlenecks, minimize the number of processes accessing the disk. Processes that access the disk include database functions and operating system functions. Parallel sessions or pipeline partitions also require disk access.