Sunday, August 28, 2016

How to calculate the SHMALL and SHMMAX Value for Oracle.

SHMALL – is the maximum total amount of shared memory pages
SHMMAX – is the maximum size in bytes of a single shared memory segment

Total RAM: 15GB

calculate SHMALL as follows in case of 15GB RAM:

TOTAL RAM IN BYTES / PAGE_SIZE

echo "15 * 1024^3 / 4096" | bc

The calculation of SHMMAX, is as follows in case of 15GB RAM:

HALF OF TOTAL RAM IN BYTES

echo "15 * 1024^3 / 2" | bc


[root@sbldcdb01 ~]# echo "15 * 1024^3 / 4096" | bc
3932160
[root@sbldcdb01 ~]#
[root@sbldcdb01 ~]# echo "15 * 1024^3 / 2" | bc
8053063680

1 comment: