Search notes:

Oracle: init parameter PARALLEL_DEGREE_POLICY

parallel_degree_policy determines the policy used to compute the degree of parallelism.
The value can be set to MANUAL, LIMITED, AUTO or ADAPTIVE.
When parallel_degree_policy is set to auto, Oracle will queue the execution of SQL statements that require parallel execution if the necessary number of parallel execution servers is not available.

See also

init parameters

Index