Oracle Database - PARALLEL_THREADS_PER_CPU Parameter

> Database > Oracle Database

1 - About

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.

[email protected]>SHOW parameter PARALLEL_THREADS_PER_CPU
NAME                                 TYPE        VALUE
------------------------------------ ----------- ---------
parallel_threads_per_cpu             INTEGER     2

3 - Documentation / Reference