Oracle Database - PARALLEL_THREADS_PER_CPU Parameter

Card Puncher Data Processing


This parameter describes the number of parallel execution processes or threads that a CPU can handle during parallel execution.

It is used to:

The default is platform-dependent and is adequate in most cases (two on most platforms).

By default, Oracle will spawn two parallel server processes per each core on most systems.

gerardnico@orcl>show parameter PARALLEL_THREADS_PER_CPU

NAME                                 TYPE        VALUE
------------------------------------ ----------- ---------
parallel_threads_per_cpu             integer     2

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 - 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: ...

Share this page:
Follow us:
Task Runner