oracle 大页配置,ORACLE 启用大页内存

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

# htt