shmmax/shmall和sga_max_size/sga_target应该设置多大
2013-04-10
linux环境安装oracle时候,如果有32G内存,CentOS 5.8 64bit安装oracle10g 64bit。那么shmmax/shmall和sga_max_size/sga_target这4个参数到底应该设置多大呢?因为每个数据库需求和压力都不尽相同,这里只能给出一些相对值供大家参考。
1、两个参考
参考值1:
OLTP服务器8G
kernel.shmall = 2097152
kernel.shmmax = 8589934592
sga_max_size big integer 4G
sga_target big integer 4G
参数值2:
OLAP服务器16G
kernel.shmall = 4194304
kernel.shmmax = 17179869184
sga_max_size big integer 12G
sga_target big integer 12G
# Controls the maximum number of shared memory segments, in pages
kernel.shmall = 4294967296
2、kernel.SHMMAX
cat /etc/sysctl.conf |grep -B1 shmmax
# Controls the maximum shared segment size, in bytes
kernel.shmmax = 68719476736
SHMMAX Availab