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


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


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).
Oracle RAC Node Memory Plan

Oracle RAC Node Memory Plan

You are advised to allocate 65% of the node physical memory to the system global area (SGA) and program global area (PGA). It is recommended that the SGA size be three times of the PGA size. Set the SGA size based on site conditions.

If the actual physical memory capacity of a compute node is 512 GB, the recommended SGA and PGA sizes are calculated as follows:

  • SGA size: 512 GB x 65% x 75% = 249.6 GB (rounded down to 240 GB)
  • PGA size: 512 GB x 65% x 25% = 83.2 GB (rounded down to 80 GB)
Updated: 2019-02-01

Document ID: EDOC1100053123

Views: 13780

Downloads: 14

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