1. huge pages 设置大小的计算脚本
附在文档最后。
2.设置oracle用户的memlock
/etc/security/limit.conf
oracle soft memlock unlimited
oracle hard memlock unlimited
3. 设置huge pages
/etc/sysctl.conf
vm.nr_hugepages = xxxxx
#sysctl -p
4.oracle启用ASMM ,停用AMM
memory_max_target / memory_target 设置为0
sga_max_size / sga_target / pga_aggregate_target 手动设置
huge pages 设置大小的计算脚本:
#!/bin/bash
#
# hugepages_settings.sh
#
# Linux bash script to compute values for the
# recommended HugePages/HugeTLB configuration
#
# Note: This script does calculation for all shared memory
# segments available when the script is run, no matter it
# is an Oracle RDBMS shared memory segment or not.
#
# This script is provided by Doc ID 401749.1 from My Oracle Support
# http://su