ITPub博客

首页 > 数据库 > Oracle > 在AIX 5.* 6.1版本上开启Oracle LargePage的方法

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

原创 Oracle 作者:sundog315 时间:2013-01-09 14:24:07 0 删除 编辑

官方文档:

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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2010-01-05

  • 博文量
    126
  • 访问量
    502560