在AIX 5.* 6.1版本上開啟Oracle LargePage的方法

sundog315發表於2013-01-09
AIOracle

官方文件：

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無法使用這個方法，只能打補丁

具體內容見：

[@more@]官方文件：

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/19423/viewspace-1060058/，如需轉載，請註明出處，否則將追究法律責任。

相關文章