Initialization Parameters, 139 of 188

PARALLEL_MAX_SERVERS

Parameter type:	Integer
Parameter class:	Static
Default value:	Derived from the values of `CPU_COUNT`, `PARALLEL_AUTOMATIC_TUNING`, and `PARALLEL_ADAPTIVE_MULTI_USER`
Range of values:	0 to 3599
Oracle Parallel Server:	All instances must have the same value (which can be zero).
Note: This parameter applies to parallel execution in exclusive mode as well as in the Oracle Parallel Server environment.
`PARALLEL_MAX_SERVERS` specifies the maximum number of parallel execution processes and parallel recovery processes for an instance. As demand increases, Oracle increases the number of processes from the number created at instance startup up to this value.
If you set this parameter too low, some queries may not have a parallel execution process available to them during query processing. If you set it too high, memory resource shortages may occur during peak periods, which can degrade performance.
See Also: Oracle8i Designing and Tuning for Performance for more information on tuning parallel execution.