PARALLEL_MAX_SERVERS

 Default value Derived from the values of CPU_COUNT, PARALLEL_THREADS_PER_CPU, and PGA_AGGREGATE_TARGET

 

Description

If this database is being used for data warehousing (DW) purposes, verify that PARALLEL_MAX_SERVERS is set to a minimum of 4*CPU_COUNT. The preferred value is 10*CPU_COUNT or higher. (NOTE: It is not possible for Oracle to accurately verify whether this database instance is being used for DW purposes. If this database is not being used for these purposes, this check can be safely ignored and suppressed.).

Risk

If this database is being used for data warehousing (DW) purposes, a low value of PARALLEL_MAX_SERVERS may prevent all parallel executions from running in parallel and the available resources from being fully utilized.

Recommendation

If this database is being used for data warehousing (DW) purposes, the value of PARALLEL_MAX_SERVERS may need to be increased. If parallel execution downgrades are observed and the CPU usage is not over 90, consider increasing the value of PARALLEL_MAX_SERVERS. The minimum value should be greater than or equal to 4*cpu_count. The recommended value is 10*cpu_count or higher. The value of the PARALLEL_MAX_SERVERS parameter can be changed by using the alter system command (alter system set = scope=both). (NOTE: It is not possible for Oracle to accurately verify whether this database instance is being used for DW purposes. If this database is not being used for these purposes, this recommendation can be safely ignored and suppressed.).