sitemap

RSS地图

收藏本站

设为首页

Oracle研究中心

当前位置:Oracle研究中心 > 产品DBA > Oracle RAC >

【学习笔记】Oracle RAC数据库运维在大内存服务器上的注意事项

时间:2016-10-23 10:22   来源:Oracle研究中心   作者:HTZ   点击:

天萃荷净 Oracle研究中心学习笔记:分享一篇关于随着去IOE,其中PC服务器的硬件相对于IBM小机要便宜很多,很多主机都配置上T的内存,下面是MOS中介绍在RAC环境中,大于300G内存以上需要考虑的一些参数情况。

Best Practices and Recommendations for RAC databases using SGA larger than 300GB (文档 ID 1619155.1)

clip_image001[10]
In this Document

Purpose
Scope
Details
Database – RAC/Scalability Community

References

APPLIES TO:

Oracle Database – Enterprise Edition – Version 10.2.0.1 to 12.1.0.1 [Release 10.2 to 12.1]
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) database using a large SGA that is greater than 300GB. 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. 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.

DETAILS

init.ora parameters:
a. Set _lm_sync_timeout to 1200
Setting this will prevent some timeouts during reconfiguration and DRM

b. Set _ksmg_granule_size to 134217728
Setting this will cut down the time needed to locate the resource for a data block.

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.

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

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.

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

Following patches are recommended:
For database on 11.2.0.3.4 PSU,
Patch 18167801 – MERGE REQUEST ON TOP OF DATABASE PSU 11.2.0.3.4 FOR BUGS 18110922 16392068
(This merged patch has many fixes that are needed for using large SGA)

For database on 11.2.0.3.5 PSU or above, please contact Oracle Support

Database – RAC/Scalability Community

Still have questions Use the communities window below to search for similar discussions or start a new discussion on this subject.

Note: Window is the LIVE community not a screenshot.

Click here to open in main browser window.

REFERENCES
NOTE:558185.1 – LMS and Real Time Priority in Oracle RAC 10g and 11g
clip_image001[2]

In this Document

Purpose

Scope

Details

Database – RAC/Scalability Community

References

APPLIES TO:

Oracle Database – Enterprise Edition – Version 10.2.0.1 to 12.1.0.1 [Release 10.2 to 12.1]

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) database using a large SGA that is greater than 300GB. 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. 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.

DETAILS

init.ora parameters:

a. Set _lm_sync_timeout to 1200

Setting this will prevent some timeouts during reconfiguration and DRM

b. Set _ksmg_granule_size to 134217728

Setting this will cut down the time needed to locate the resource for a data block.

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.

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

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.

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

Following patches are recommended:

For database on 11.2.0.3.4 PSU,

Patch 18167801 – MERGE REQUEST ON TOP OF DATABASE PSU 11.2.0.3.4 FOR BUGS 18110922 16392068

(This merged patch has many fixes that are needed for using large SGA)

For database on 11.2.0.3.5 PSU or above, please contact Oracle Support

Database – RAC/Scalability Community

Still have questions Use the communities window below to search for similar discussions or start a new discussion on this subject.

Note: Window is the LIVE community not a screenshot.

Click here to open in main browser window.

REFERENCES

NOTE:558185.1 – LMS and Real Time Priority in Oracle RAC 10g and 11g

本文固定链接: http://www.htz.pw/2014/05/25/oracle-rac%e8%bf%90%e8%a1%8c%e5%9c%a8300g%e5%86%85%e5%ad%98%e4%bb%a5%e4%b8%8a%e9%9c%80%e8%a6%81%e8%80%83%e8%99%91%e7%9a%84%e4%b8%9c%e8%a5%bf.html | 认真就输

--------------------------------------ORACLE-DBA----------------------------------------

最权威、专业的Oracle案例资源汇总之【学习笔记】Oracle RAC数据库运维在大内存服务器上的注意事项

本文由大师惜分飞原创分享,网址:http://www.oracleplus.net/arch/1042.html

Oracle研究中心

关键词:

ORACLE RAC运行在300G内存以上需要考虑的事项

Oracle RAC大内存的影响