setting of parallel_max_servers parameters in Oracle

The Parallel_max_severs parameter sets the maximum number of processes available for parallel execution, and the default value for this parameter is as follows:

1. When Pga_aggregate_target >0

parallel_max_servers= (Cpu_count x parallel_threads_per_cpu x 10)

2. When Parallel_max_servers is not set

parallel_max_servers= (Cpu_count x parallel_threads_per_cpu x 5)

The default setting may not be sufficient, and we usually set the Parallel_max_servers parameter according to the highest degree of parallelism (DOP):

2 x DOP x number_of_concurrent_users

Author: 51cto Blog Oracle Little Bastard

Back to the column page: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/