Oracle Database - CPU_COUNT parameter

Card Puncher Data Processing


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:

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

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

gerardnico@gorcl>show parameter CPU_COUNT

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

Documentation / Reference

Discover More
Card Puncher Data Processing
Oracle Database - (Degree|Degree of Parallelism (DOP))

Oracle's parallel execution framework enables you to either explicitly chose - or even enforce - a specific degree of parallelism (DOP) or to rely on Oracle to control it. A degree of 1 is the default...
Card Puncher Data Processing
Oracle Database - ADDM (Automated Database Diagnostic Monitor) - Automatic Performance Diagnostics Tool

ADDM (Automated Database Diagnostic Monitor) is available since Oracle 10g. are useful features for performance tuning and troubleshooting. ADDM reports the most significant performance problems between...
Card Puncher Data Processing
Oracle Database - PARALLEL_MAX_SERVERS parameter

This parameter determines the maximum number of parallel servers that may be started for a database instance, should there be demand for them. The default value on Oracle Database 10g and higher is:...
Card Puncher Data Processing
Oracle Database - PARALLEL_SERVERS_TARGET parameter

PARALLEL_SERVERS_TARGET is a initialization parameter that specifies the number of parallel server processes allowed to run parallel statements before statement queuing will be used. Where: ...
Card Puncher Data Processing
Oracle Database - PARALLEL_THREADS_PER_CPU Parameter

This parameter describes the number of parallel execution processes or threads that a CPU can handle during parallel execution. It is used to: calculate the default degree of parallelism for the...

Share this page:
Follow us:
Task Runner