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