Shared memory:
SHMMAX: This parameter sets the largest shared memory segment size allowed by the kernel, in bytes. Default value for this parameter is 33554432. With this value, database creation may fail. Therefore it is advisable to increase the value of SHMMAX, such that, Oracle will allocate the SGA in one segment.
For a system with 4 GB RAM, the suggested value of SHMMAX is 2 GB. Maximum value of SHMMAX that could be set is 4 GB - 1.
echo "2147483648" > /proc/sys/kernel/shmmax
SHMMNI: This parameter sets the maximum number of shared memory segments for the whole system.
echo "4096" > /proc/sys/kernel/shmmni
SHMALL: This parameter sets the total amount of shared memory that can be used at one time on the system, in bytes.
echo "2097152" > /proc/sys/kernel/shmall
Partager