PARALLEL_THREADS_PER_CPU
|
Property
|
Description
|
|
Parameter type
|
Integer
|
|
Default value
|
Operating system-dependent, usually 2
|
|
Modifiable
|
ALTER SYSTEM
|
|
Range of values
|
Any nonzero number
|
Note:
This parameter applies to parallel execution in exclusive mode as well as in a 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.
PARALLEL_THREADS_PER_CPU指定实例默认的并行度，确定合适的并行和负载均衡算法。这个参数描述并行执行进程数，或者在并行执行期间CPU能处理的线程数。
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.
默认值依赖于平台，在大多数情况下都是合适的。当执行一个典型的并行查询时，服务器出现过载的情况，应该减少这个参数的值。如果系统在I/O的边界应该增加这个值。
|
