了解Maclean Liu|向Maclean Liu提问 Oracle ALLSTARS 全明星(群内有多位Oracle高级售后support,N位OCM和ACE) QQ群 # QQ群号:23549328 # 已经升级到 2000人群,空位多多。欢迎有一定基础的Oracle骨友加入,现在入群需要经过Maclean的技术面试,欢迎面试,请加QQ号:47079569 为好友参加面试 2群基础群 适合刚入门的同学,会共享最佳入门实践和资料 QQ群 # QQ群号:171092051 # 已经升级到 500人的超级群,空位多多,无需面试

11.2.0.3 实例启动现在提供Large Pages Information大内存页信息了

刚才发现在目前最新的11.2.0.3版本中实例instance startup时alert.log 中会提供Large Pages Information 大内存页的信息了:  
Starting ORACLE instance (normal)
****************** Large Pages Information *****************

Total Shared Global Region in Large Pages = 0 KB (0%)

Large Pages used by this instance: 0 (0 KB)
Large Pages unused system wide = 0 (0 KB) (alloc incr 16 MB)
Large Pages configured system wide = 0 (0 KB)
Large Page size = 2048 KB

RECOMMENDATION:
  Total Shared Global Region size is 1202 MB. For optimal performance,
  prior to the next instance restart increase the number
  of unused Large Pages by atleast 601 2048 KB Large Pages (1202 MB)
  system wide to get 100% of the Shared
  Global Region allocated with Large pages
***********************************************************

Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options.
ORACLE_HOME = /s01/orabase/product/11.2.0/dbhome_3
System name:Linux
Node name:vrh2.oracle.com
Release:2.6.18-274.el5
Version:#1 SMP Mon Jul 25 13:17:49 EDT 2011
Machine:x86_64
Using parameter settings in server-side spfile /s01/orabase/product/11.2.0/dbhome_3/dbs/spfileEMREP.ora
  该Large Pages Information还附有配置Large Page的RECOMMENDATION设置,当SGA_Target=1202MB时,推荐配置601个2048K页。 注意Large Page不能和11g AMM 自动内存管理一起使用,否则AMM将失去其意义。

posted on 2013-03-19 00:48  Oracle和MySQL  阅读(637)  评论(0编辑  收藏  举报

导航