Linux x86 and x86-64 system Shmmax maximum value
Reference Original:
Maximum SHMMAX values for Linux x86 and x86-64 (file ID 567506.1)
Goal:
Problem 1:32-bit (x86) maximum value in Linux system systems?
Problem 2:64-bit (x86-64) maximum value in Linux system systems?
How to resolve:
Answer 1:
Oracle Global Customer Support official recommendation SHMMAX The maximum value is less than 4GB, or 4294967295
The maximum size of a shared memory segment is limited by the available user addressing space.
In the 32bit system, it is 4GB.
Answer 2:
Oracle Global Customer Support official recommendation SHMMAX The maximum value is 1/2 of physical memory
The maximum size of a shared memory side is limited by the available user addressing space. In 64bit systems, this theoretical value is 2 of the 64-time Square. Therefore, the theoretical limit of Shmmax is the size of the physical memory. However, the actual use of all memory as Shmmax can lead to a potential condition: no memory can be used to do anything else.
Therefore, a more ideal physical limit for SHMMAX is physical memory -2gb
In an Oracle DB environment, this physical limitation still causes insufficient memory to be used for other required functions (functions).
So. The general "Oracle maximum" for SHMMAX is 1/2 of physical memory.
Very much Oracle customer a higher fraction, at their discretion
Occasionally, the customer would mistakenly think: according to the recommended settings SHMMAX is used to limit all the SGA, this is not right.
Based on the recommended settings Shmmax only causes some shared memory segments to be used on the total SGA. For details, see the MOS article:
Document 15566.1, "SGA, SHMMAX, semaphores and Shared Memory explained"
In memory configuration, the same need to consider the kernel parameters Kernel.shmall, all the shared memory parameter size is the system's main energy use, the same page unit
See MOS article:
Document 301830.1 upon startup of Linux database get ora-27102:out of memory linux-x86_64 Error:28:no space left on Dev Ice
"Translator MoS article" Linux x86 and x86-64 system Shmmax max