|Oracle® Database Reference
11g Release 2 (11.2)
Part Number E17110-04
|Range of values||
CPU_COUNT specifies the number of CPUs available for Oracle Database to use. Various components of Oracle Database are configured based on the number of CPUs, such as the Optimizer, Parallel Query, and Resource Manager.
CPU_COUNT is set to
0 (its default setting), then Oracle Database continuously monitors the number of CPUs reported by the operating system and uses the current count. If
CPU_COUNT is set to a value other than
0, then Oracle Database will use this count rather than the actual number of CPUs, thus disabling dynamic CPU reconfiguration. When Resource Manager is enabled, setting
CPU_COUNT limits the CPU utilization to approximately
CPU_COUNTto a value greater than the current number of CPUs results in an error. However, if
CPU_COUNTis set to a value greater than the current number of CPUs in the initialization parameter file, then
CPU_COUNTis capped to the current number of CPUs.