This content has been marked as final. Show 13 replies
Thanks for reply.
I read your link it was quite helpfull and I also read the link which is given below which is mentined in your link:
But it adds one more doubt....
When I am checking the value using
cat /etc/sysctl.conf | grep -i shmmax
o/p are different.
How it is possible? Which value should we consider for calculation?
In my environment value is same
If you have done any changes into /etc/sysctl.conf file,It will be updated only after reboot
[oracle@2XSSFD1 ~]$ cat /etc/sysctl.conf | grep -i shmmax # Oracle-Validated setting for kernel.shmmax is 4398046511104 on x86_64 and 4294967295 on i386 architecture. Refer Note id 567506.1 kernel.shmmax = 4398046511104 [oracle@2XSSFD1 ~]$ cat /proc/sys/kernel/shmmax 4398046511104
or By using below mentioned command.
# /sbin/sysctl -p
I read that links.....!
According to the links I will change my value of SHMMAX in sysctl.conf file and after that will execute "sysctl -p".
One last thing in my mind is that with respect to links which I read for this topic.....
According to the link which is given below I found one sentence that +"Keep in mind that the maximum value of the SHMMAX parameter is 4GB"+
According to the link of Oracle docs:
it is mentioned that size of SHMMAX should be half of the RAM.
So which statement is right?
And in my UAT server RAM is 32G and SHMMAX size is 16G and all db are working fine. So should I give value of SHMMAX 16G for production also?