PARALLEL_MAX_SEVERS参数设置并行执行可用的最大进程数量,该参数的缺省值如下得出:
1.当PGA_AGGREGATE_TARGET >0时
PARALLEL_MAX_SERVERS= (CPU_COUNT x PARALLEL_THREADS_PER_CPU x 10)
2.当PARALLEL_MAX_SERVERS未设置
PARALLEL_MAX_SERVERS=(CPU_COUNT x PARALLEL_THREADS_PER_CPU x 5)
缺省设置可能并不足够,通常我们根据最高的并行度(DOP)来设置PARALLEL_MAX_SERVERS参数:
2 x DOP x NUMBER_OF_CONCURRENT_USERS
oracle视频教程请关注:http://u.youku.com/user_video/id_UMzAzMjkxMjE2.html