Oracle Database - CPU_COUNT parameter

About

CPU_COUNT specifies the number of CPUs core (processor) available for Oracle Database to use.

CPU count is an automatically derived parameter by the Oracle system and is used to determine:

• the default number of parallel servers
• and the default degree of parallelism.

Various components of Oracle Database are configured based on the number of CPUs, such as:

• the SQL Engine - Query Optimizer (Query Optimization),
• Parallel Query,
• and Resource Manager.

When Resource Manager is enabled, setting CPU_COUNT limits the CPU utilization to approximately CPU_COUNT processors.

Articles Related

gerardnico@gorcl>show parameter CPU_COUNT

NAME                                 TYPE        VALUE
------------------------------------ ----------- ----------
cpu_count                            integer     8

Documentation / Reference

• Oracle SQL Parallel Execution - An Oracle White Paper - June 2008
• Cpu Count 11g Documentation