在AIX 5.* 6.1版本上开启Oracle LargePage的方法

官方文档：How to enable Large Page Feature on AIX-Based Systems [ID 372157.1]

1. First check the current capabilities: # lsuser -a capabilities oracle

Note: only the root user can display the capabilities attribute.

2. Add the CAP_BYPASS_RAC_VMM and CAP_PROPAGATE capabilities to the list of capabilities already assigned to this user ID, if any:
#chuser capabilities=CAP_BYPASS_RAC_VMM,CAP_PROPAGATE oracle

3. Configure the AIX large page pool by calculating the number of large pages required for the SGA:
num_of_large_pages = INT((total_SGA_size-1)/16MB)+1

Note that although we are dealing with integer values, some rounding up must be considered, since rounding down makes no sense when trying to fit things into memory. For example, take an SGA size of 9999220736:

9999220736-1/(16*1024*1024)=595.99999994

Here, the integer calc will end up with a result of 595, but given the actual figure is higher, we would need to round up to 596 rather than accept the base figure of 595.

4. Configure the number and size of large pages:
#vmo -p -o lgpg_regions=num_of_large_pages -o lgpg_size=16777216

5. Change lru_file_repage, the default is 1:

#vmo -o lru_file_repage=0

几点注意：

1.RAC

When using large pages on an Oracle Real Application Cluster (RAC) database, where the srvctl command is used to start and stop the RAC database instances, it is also necessary to set the CAP_BYPASS_RAC_VMM and CAP_PROPAGATE capabilities for the root user ID.

2.由于BUG：7226548，10.2.0.4及10.2.0.5是无法使用LargePage的，使用svmon -G可以观察到。如果是非RAC方式，可以设置

For csh:
setenv ORACLE_SGA_PGSZ 16m

For ksh:
export ORACLE_SGA_PGSZ=16m

之后启动Oracle。但我测试RAC无法使用这个方法，只能打补丁

具体内容见：AIX: Upgraded To 10.2.0.4 (or 10.2.0.5) And Large Page Memory Is No Longer Used [ID 728444.1]

[@more@]官方文档： How to enable Large Page Feature on AIX-Based Systems [ID 372157.1]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/19423/viewspace-1060058/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/19423/viewspace-1060058/