1.240 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 |
Operating system-dependent, usually |
|
Modifiable |
|
|
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:
-
Oracle Database SQL Tuning Guide for more information about parallel execution
-
Oracle Database VLDB and Partitioning Guide for information about how the optimizer automatically determines the degree of parallelism for a statement