oracle 11g rac的2个节点,alert日志里能看到如下信息:
************************ Large Pages Information *******************
Per process system memlock (soft) limit = 64 KB
Total Shared Global Region in Large Pages = 0 KB (0%)
Large Pages used by this instance: 0 (0 KB)
Large Pages unused system wide = 0 (0 KB)
Large Pages configured system wide = 0 (0 KB)
Large Page size = 2048 KB
RECOMMENDATION:
Total System Global Area size is 44 GB. For optimal performance,
prior to the next instance restart:
- Increase the number of unused large pages by
at least 22529 (page size 2048 KB, total size 44 GB) system wide to
get 100% of the System Global Area allocated with large pages - Large pages are automatically locked into physical memory.
Increase the per process memlock (soft) limit to at least 44 GB to lock
100% System Global Area’s large pages into physical memory
系统环境如下:
1,操作系统是CentOS release 6.9 (Final)
2,内存:512G
[oracle@DB2 ~]$ free -m
total used free shared buffers cached
Mem: 516918 186647 330271 85459 961 129227
-/+ buffers/cache: 56457 460460
Swap: 65535 0 65535
3,系统内核参数配置如下:
[root@DB2 ~]# cat /etc/sysctl.conf
kernel.shmall = 137438953472
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
fs.file-max = 6815744
fs.aio-max-nr = 1048576
net.ipv4.tcp_tw_reuse = 1
net.ipv4.tcp_tw_recycle = 1
kernel.core_uses_pid = 1
4,系统资源限制数配置如下:
[root@DB2 ~]# cat /etc/security/limits.conf
grid soft nproc 2047
grid hard nproc 16384
grid soft nofile 1024
grid hard nofile 65536
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
数据库SGA当前是44G
SQL> show parameter sga
NAME TYPE VALUE
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 44G
sga_target big integer 44G
那句alert里面的提示,这是让我增加SGA吗?
还得增加large pages成22529?
这个怎么增加呢?