oracle 在 aix上large page特性

調整16m記憶體的步驟
1、檢視oracle使用者是否有CAP_BYPASS_RAC_VMM和CAP_PROPAGATE
#lsuser capabilities oracle

2、如果不存在CAP_BYPASS_RAC_VMM和CAP_PROPAGATE，則修改oracle使用者，授予CAP_BYPASS_RAC_VMM和CAP_PROPAGATE
#chuser capabilities=CAP_BYPASS_RAC_VMM,CAP_PROPAGATE oracle

3、如果是rac資料庫，需要為root使用者分配CAP_BYPASS_RAC_VMM和CAP_PROPAGATE，否則，當使用srvctl命令啟動例項的事後不能使用大記憶體
#chuser capabilities=CAP_BYPASS_RAC_VMM,CAP_PROPAGATE root

4、調整作業系統引數
#vmo -p -o v_pinshm=1
#vmo -p -o maxpin%=53 #maxpin值的大小的計算公式：

When using the maxpin% option, it is important that the amount of pinned memory
exceeds the Oracle SGA size by at least 3 percent of the real memory on the system,
enabling free pinnable memory for use by the kernel. For example, if you have 2 GB of
physical memory and you want to pin the SGA by 400 MB (20 percent of the RAM)

#vmo -p -o lgpg_regions=500 -o lgpg_size=16777216 #lgpg_regions值的大小的計算公式：num_of_large_pages = INT((total_SGA_size-1)/16MB)+1

#vmo -p -o lru_file_repage=0

5、如果資料庫版本是oracle 10.2.0.4，需要打補丁7226548

6、設定oracle引數lock_sga=true

7、重新啟動例項

8、檢視lgpg使用情況，如果最下面L 16 MB 那行virtual的virtual列不為0，則證明lgpg生效
testdb4[/]#svmon -G
size inuse free pin virtual
memory 6094848 5106798 988050 1217341 5307443
pg space 6291456 1409607

work pers clnt other
pin 975838 0 0 221023
in use 4692390 0 393928

PageSize PoolSize inuse pgsp pin virtual
s 4 KB - 4925918 1409607 1076013 5147043
m 64 KB - 10025 0 7553 10025
L 16 MB 500 0 0 500 385

錯誤處理
1、當出現如下錯誤的事後，是因為剩餘記憶體不足，需要將oracle例項關掉重新執行命令，或將
testdb4[/]#vmo -p -o lgpg_regions=500 -o lgpg_size=16777216
Setting lgpg_size to 16777216 in nextboot file
Setting lgpg_regions to 500 in nextboot file
Warning: although the change concerns a dynamic tunable, bosboot should be run to optimally restore these settings at reboot
vmo: 1485-124 Error setting lgpg_size lgpg_regions
The system was unable to completely satisfy the request

[@more@]