Oracle9i Database Reference Release 2 (9.2) Part Number A96536-01 |
|
Initialization Parameters, 156 of 222
Parameter type |
Integer |
Default value |
Operating system-dependent, usually 2 |
Parameter class |
Dynamic: |
Range of values |
Any nonzero number |
Note: This parameter applies to parallel execution in exclusive mode as well as in the Oracle9i Real Application Clusters environment. |
PARALLEL_THREADS_PER_CPU
specifies the default degree of parallelism for the instance and determines the parallel adaptive and load balancing algorithms. The parameter describes the number of parallel execution processes or threads that a CPU can handle during parallel execution.
The default is platform-dependent and is adequate in most cases. You should decrease the value of this parameter if the machine appears to be overloaded when a representative parallel query is executed. You should increase the value if the system is I/O bound.
See Also:
Oracle9i Database Performance Tuning Guide and Reference for more information on tuning parallel execution |
|
![]() Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. |
|