1.250 PARALLEL_MIN_DEGREE
PARALLEL_MIN_DEGREE
controls the minimum degree of parallelism computed by automatic degree of parallelism.
Property | Description |
---|---|
Parameter type |
String |
Syntax |
|
Default value |
1 |
Modifiable |
|
Modifiable in a PDB |
Yes |
Basic |
No |
Oracle RAC |
A different value can be set on different instances. |
The value of PARALLEL_MIN_DEGREE
is either a number that corresponds to the lower bound on the degree of parallelism computed by automatic degree of parallelism, or the string value CPU
, which is computed by the function CPU_COUNT
* PARALLEL_THREADS_PER_CPU
.
The default value of PARALLEL_MIN_DEGREE
is 1.
Note:
PARALLEL_MIN_DEGREE
has no impact in either of these cases:
-
When the value of
PARALLEL_MIN_DEGREE
is greater than the value ofCPU_COUNT
-
When the object is Oracle-owned, such as a dictionary table or view created on a dictionary table
See Also:
-
Oracle Database VLDB and Partitioning Guide for information about how the optimizer automatically determines the degree of parallelism for a statement