|Oracle9i Database Reference
Release 1 (9.0.1)
Part Number A90190-02
Initialization Parameters, 146 of 220
Derived from the value of
|Range of values||
PARALLEL_ADAPTIVE_MULTI_USER, when set to
true, enables an adaptive algorithm designed to improve performance in multiuser environments that use parallel execution. The algorithm automatically reduces the requested degree of parallelism based on the system load at query startup time. The effective degree of parallelism is based on the default degree of parallelism, or the degree from the table or hints, divided by a reduction factor.
The algorithm assumes the following:
parameter is set to
Tables and hints use the default degree of parallelism.
Oracle9i Database Performance Guide and Reference for more information on tuning parallel execution and on the algorithm described here