ITPub博客

首页 > Linux操作系统 > Linux操作系统 > parallel_max_servers

parallel_max_servers

原创 Linux操作系统 作者:psufnxk2000 时间:2013-11-05 22:44:14 0 删除 编辑
Health Check Alert: PARALLEL_MAX_SERVERS should be greater than or equal to the minimum recommended value (Only applies to data warehousing) (Doc ID 957430.1) 在数据仓库中, parallel_max_servers应该大于等于 最小的推荐值(4*cpu_count)
如果有并行 性能问题并且 cpu使用没有超过90,考虑增加这个参数 ,推荐 10*cpu_count或更高



In this Document 
  Purpose 
  Scope 
  Health Check 10730: PARALLEL_MAX_SERVERS should be greater than or equal to the minimum recommended value (Only applies to data warehousing) 
     Description 
     Risk 
     Recommendation 
  References 
Applies to:


Oracle Server - Enterprise Edition - Version: 9.2 to 11.2
Information in this document applies to Any Unix,Any Microsoft Windows,.
Health Check Category: Performance
Severity Level: Warning
Purpose


This document provides a quick reference explaining the following Health Check Alert:


Scope


Before reading this article, the user should have a good understanding of Data Warehouse.
Health Check 10730: PARALLEL_MAX_SERVERS should be greater than or equal to the minimum recommended value (Only applies to data warehousing)


IMPORTANT


My Oracle Support provides a proactive health check that automatically detects and notifies you of the existence of this issue before it impacts your business. To leverage this proactive support capability, install the Oracle Configuration Manager (OCM). Information on installing the Oracle Configuration Manager can be found on the Collector tab of My Oracle Support. To view the full portfolio of health checks available, see Note 868955.1
Description


Verifies that PARALLEL_MAX_SERVERS is set to a minimum of 4*CPU_COUNT which is needed for databases that are used for data warehousing (DW) purposes. 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).


References


Document 30790.1 Init.ora Parameter "PARALLEL_MAX_SERVERS" Reference Note

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25099483/viewspace-775784/,如需转载,请注明出处,否则将追究法律责任。

上一篇:
请登录后发表评论 登录
全部评论

注册时间:2011-05-31

  • 博文量
    215
  • 访问量
    625940