No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>Search

Reminder

To have a better experience, please upgrade your IE browser.

upgrade

KunLun Mission Critical Server Oracle Database Oracle 12c R1 (RAC) Best Practice 02

Rate and give feedback:
Huawei uses machine translation combined with human proofreading to translate this document to different languages in order to help you better understand the content of this document. Note: Even the most advanced machine translation cannot match the quality of professional translators. Huawei shall not bear any responsibility for translation accuracy and it is recommended that you refer to the English document (a link for which has been provided).
SGA HugePages Configuration

SGA HugePages Configuration

If the Oracle SGA size is greater than 100 GB, the following parameters need to be initialized during installation (see Oracle document 1619155.1).

a. Set _lm_sync_timeout to 1200  (this recommendation is valid only for databases that are 12.2 and lower).
b. Set _lm_tickets to 5000    (this recommendation is valid only for databases that are 12.2 and lower).

Set the following parameters according to the following formulas:

c. Set shared_pool_size to 15% or larger of the total SGA size.
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 gcs_server_processes to the twice of the default number of lms processes that are allocated.    (this recommendation is valid only for databases that are 12.2 and lower)
Download
Updated: 2019-02-01

Document ID: EDOC1100053123

Views: 14688

Downloads: 14

Average rating:
This Document Applies to these Products
Related Documents
Related Version
Share
Previous Next