Maximum SHMMAX values for Linux x86 and x86-64 (Doc ID 567506.1)
Applies to:
Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 11.2.0.2 - Release: 9.2 to 11.2Linux x86
Generic Linux
Obsolete Linux Intel (64-bit)
Red Hat Enterprise Linux Advanced Server x86-64 (AMD Opteron Architecture)
Linux x86-64
Goal
QUESTION 1
===========
What is the maximum value of SHMMAX for a 32-bit (x86) Linux system?
QUESTION 2
===========
What is the maximum value of SHMMAX for a 64-bit (x86-64) Linux system?
Solution
ANSWER 1
============
Oracle Global Customer Support officially recommends a " maximum" for SHMMAX of just less than 4Gb, or 4294967295.
The
maximum size of a shared memory segment is limited by the size of the
available user address space. On 32-bit systems, this is a theoretical
4GB. The maximum possible value for SHMMAX is just less than 4Gb, or
4294967295. Setting SHMMAX to 4GB exactly will give you 0 bytes as max,
as this value is interpreted as a 32-bit number and it wraps around.
ANSWER 2
===========
Oracle Global Customer Support officially recommends a " maximum" for SHMMAX of "1/2 of physical RAM".
The
maximum size of a shared memory segment is limited by the size of the
available user address space. On 64-bit systems, this is a theoretical
2^64bytes. So the "theoretical limit" for SHMMAX is the amount of
physical RAM that you have. However, to actually attempt to use such a
value could potentially lead to a situation where no system memory is
available for anything else. Therefore a more realistic "physical
limit" for SHMMAX would probably be "physical RAM - 2Gb".
In an
Oracle RDBMS application, this "physical limit" still leaves inadequate
system memory for other necessary functions. Therefore, the common
"Oracle maximum" for SHMMAX that you will often see is "1/2 of physical
RAM". Many Oracle customers chose a higher fraction, at their
discretion.
Occasionally, Customers may erroneously think that
that setting the SHMMAX as recommended in this NOTE limits the total
SGA. That is not true. Setting the SHMMAX as recommended only causes
a few more “shared memory segments” to be used for whatever total SGA
that you subsequently configure in Oracle. For additional detail,
please see Document 15566.1, "SGA, SHMMAX, Semaphores and Shared Memory Explained"
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/19423/viewspace-1043528/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle11g R2 for linux x86 , Linux x86-64 下載OracleLinux
- ES 筆記三十五:排序及 Doc Values & Field Data筆記排序
- Linux OS Service 'ntpd' (Doc ID 551704.1)Linux
- Certification Information for Oracle Database on Linux x86-64 [ID 1304727.1]ORMOracleDatabaseLinux
- SabayonLinux x86/x86-64迷你版3.0釋出(轉)Linux
- Oracle Linux and External Storage Systems (Doc ID 753050.1)OracleLinux
- 【Linux】kernel.shmmax和shmall設定LinuxHMM
- HugePages on Oracle Linux 64-bit (Doc ID 361468.1)OracleLinux
- 配置 HugePages for Oracle on Linux (x86-64)OracleLinux
- Master Note of Linux OS Requirements for Database Server (Doc ID 851598.1)ASTLinuxUIREMDatabaseServer
- Setting up ASM on linux with LVM (Doc ID 292348.1)ASMLinuxLVM
- Oracle Grid/RAC 11.2.0.4 on Oracle Linux 7 (Doc ID 1951613.1)OracleLinux
- Linux 核心(kernel)引數 sysctl.conf , shmmaxLinuxHMM
- Linux 下kernel.shmmax 的設定問題LinuxHMM
- 修改vip (Doc ID 276434.1)
- Shell Script to Calculate Values Recommended Linux HugePagesLinux
- Django中values()和values_list()Django
- Linux上shmmax引數的設定及含義LinuxHMM
- create database link中的identified by valuesDatabaseIDE
- Build gdbserver for x86 AndroidUIServerAndroid
- Linux之x86架構Linux架構
- RealPlayer for Linux/x86(轉)Linux
- 關於Linux 下kernel.shmmax 的設定問題 。LinuxHMM
- Linux上shmmax引數的設定及含義(轉)LinuxHMM
- fedora 11 x86-64 下安裝 QQ for linuxLinux
- HANGFG User Guide (Doc ID 362094.1)GUIIDE
- How To Check if Asynchronous I/O is Working On Linux (Doc ID 237299.1)Linux
- How to Prepare Storage for ASM (Doc ID 452924.1)ASM
- Subarray Distinct Values
- LeetCode-Sliding Window MaximumLeetCode
- [LeetCode] 962. Maximum Width RampLeetCode
- 【shmmax】由於shmmax設定過小導致dbca建庫無法完成HMM
- 高效的SQL(index values與index column values關係?)SQLIndex
- ipcs、ipcrm、sysresv、kernel.shmmaxHMM
- shmmax的設定問題HMM
- Android x86 設定豎屏Android
- Android開發簡單教程.docAndroid
- SQLT Diagnostic Tool (Doc ID 215187.1)SQL