ORACLE RAC 内存SGA，PGA配置超过300G的问题

在PC服务器发展到今天，在服务器内存方面早已经超越了小型机的内存配置。在一般的ORACLE 服务器上面，配置512G，1T，2T的内存是比较常见的事情。
但是在做ORACLE RAC的时候，特别是在进行安装的时候，在配置ORACLE内存大于300G的时候，需要注意一些问题，需要把一些默认的参数进行修改。。

在一次ORACLE性能问题中从AWR报告上看 gcs drm freeze in enter server mode、gc cr block congested 、gc current grant busy占比较大的比例，这些都与DRM特性有关。

所以需要关闭一些特性。可以参照ORACLE的官方文档
https://support.oracle.com/epmos/faces/DocumentDisplay?id=1619155.1&_adf.ctrl-state=1daet72ccg_241&_afrLoop=224951496521940

Best Practices and Recommendations for RAC databases with SGA size over 100GB (Doc ID 1619155.1)

To Bottom

---

In this Document Purpose Scope Details   Database - RAC/Scalability Community References APPLIES TO: Oracle Database - Enterprise Edition - Version 11.2.0.3 and later Information in this document applies to any platform. PURPOSE The goal of this note is to provide best practices and recommendations to users of Oracle Real Application Clusters (RAC) databases using very large SGA (e.g. 100GB) per instance (note that RAC assumes homogeneously sized SGAs across the cluster). This document is compiled and maintained based on Oracle's experience with its global RAC customer base. This is not meant to replace or supplant the Oracle Documentation set, but rather, it is meant as a supplement to the same. It is imperative that the Oracle Documentation be read, understood, and referenced to provide answers to any questions that may not be clearly addressed by this note. All recommendations should be carefully reviewed by your own operations group and should only be implemented if the potential gain as measured against the associated risk warrants implementation. Risk assessments can only be made with a detailed knowledge of the system, application, and business environment. As every customer environment is unique, the success of any Oracle Database implementation, including implementations of Oracle RAC, is predicated on a successful test environment. Oracle Support has identified 100 GB as a baseline for large SGA's that would benefit from the recommendations provided in this note. However, this is just a baseline, and it is possible for similar(but smaller) SGA's to benefit from these recommendations. It is thus imperative that any recommendations from this note are thoroughly tested and validated using a testing environment that is a replica of the target production environment before being implemented in the production environment to ensure that there is no negative impact associated with the recommendations that are made SCOPE This article applies to all new and existing RAC implementations. This is for RAC databases only as most of the parameters listed in here are for RAC Database only. DETAILS  Note that the recommendations presented in this note are a result of the experience from working on databases with SGA of 1 TB and 2.6 TB. Also, the databases with SGA of 100GB and 300GB also benefited from the recommendations init.ora parameters: a.       Set _lm_sync_timeout to 1200             Setting this will prevent some timeouts during reconfiguration and DRM. It's a static parameter and rolling restart is supported. b.       Set _ksmg_granule_size to 134217728            Setting this will cut down the time needed to locate the resource for a data block. It's a static parameter and rolling restart is supported. c.       Set shared_pool_size to 15% or larger of the total SGA size.         For example, if SGA size is 1 TB, the shared pool size should be at least 150 GB. It's a dynamic parameter. d.       Set _gc_policy_minimum to 15000         There is no need to set _gc_policy_minimum if DRM is disabled by setting _gc_policy_time = 0. _gc_policy_minimum is a dynamic parameter, _gc_policy_time is a static parameter and rolling restart is not supported. To disable DRM, instead of _gc_policy_time, _lm_drm_disable should be used as it's dynamic. e.       Set _lm_tickets to 5000         Default is 1000.   Allocating more tickets (used for sending messages) avoids issues where we ran out of tickets during the reconfiguration. It's a static parameter and rolling restart is supported. When increasing the parameter, rolling restart is fine but a cold restart can be necessary when decreasing. f.       Set gcs_server_processes to the twice the default number of lms processes that are allocated.         The default number of lms processes depends on the number of CPUs/cores that the server has,          so please refer to the gcs_server_processes init.ora parameter section in the Oracle Database Reference Guide          for the default number of lms processes for your server.  Please make sure that the total number of lms processes          of all databases on the server is less than the total number of CPUs/cores on the server.  Please refer to the  Document 558185.1          It's a static parameter and rolling restart is supported.   Following patches are recommended: 11.2.0.3.5 DB PSU or above is highly recommended to address known issues with large SGA sizes. For SGA that is larger than 4 TB and for Linux platform, BUG 18780342 - LINUX SUPPORT FOR > 4TB SGA

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

转载于:http://blog.itpub.net/28869493/viewspace-2138280/