1.256 PARALLEL_THREADS_PER_CPU

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

Property Description

Parameter type

Integer

Default value

1

Modifiable

ALTER SYSTEM

Modifiable in a PDB

No

Range of values

Any nonzero number

Basic

No

Note:

This parameter applies to parallel execution in exclusive mode as well as in an Oracle Real Application Clusters environment.

This parameter is used in determining the default values of other parallel execution related parameters, for example, PARALLEL_MAX_SERVERS. It is also used in determining the default degree of parallelism for SQL statements, and determining the upper bound for the degree of parallelism in automatic degree of parallelism. The default value is adequate in most cases.

See Also: