大页在oracle数据库是否使用,在Oracle 11.2.0.3.0上开启大页（hugepages）的详细解析...

3、对hugepages_settings.sh这个脚本授可执行的权限

[Oracle@mydb admin]$  chmod +x hugepages_settings.sh

4、执行hugepages_settings.sh，计算hugepages的值为1028M

[oracle@mydb admin]$ ./hugepages_settings.sh

This script is provided by Doc ID 401749.1 from My Oracle Support

(http://support.oracle.com) where it is intended to compute values for

the recommended HugePages/HugeTLB configuration for the current shared

memory segments. Before proceeding with the execution please note following:

* For ASM instance, it needs to configure ASMM instead of AMM.

* The 'pga_aggregate_target' is outside the SGA and

you should accommodate this while calculating SGA size.

* In case you changes the DB SGA size,

as the new SGA will not fit in the previous HugePages configuration,

it had better disable the whole HugePages,

start the DB with new SGA size and run the script again.

And make sure that:

* Oracle Database instance(s) are up and running

* Oracle Database 11g Automatic Memory Management (AMM) is not setup

(See Doc ID 749851.1)

* The shared memory segments can be listed by command:

# ipcs -m

Press Enter to proceed...

Recommended setting: vm.nr_hugepages = 1028

得出大页的大小为1028页(注：一页为2M，这个值不可改，1028*2M=2056M)，实际上hugepages与参数sga_max_size有关，比sga_max_size的值稍微大一点点(比SGA_MAX_SIZE最少要多加一页，2M的页不要分配超过sga_max_size太多，会造成内存的浪费)：

gyj@OCM> show parameter sga_max_size

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

sga_max_size big in