0 积分	0 好友	11 主题

发消息

[SQL调优] RAC 11.2.0.2 ADDM报告 Virtual Memory Paging性能问题on HPUnix itanium 11.3

1^#

发表于 2013-7-3 15:57:32 | 查看: 4263| 回复: 2

本帖最后由 ccboceb7 于 2013-7-3 16:15 编辑

数据库的ADDM报告中显示Virtual Memory Paging严重影响了性能，请帮确认一下是哪儿有问题？谢谢了。
OS : $uname -a
      HP-UX dbasmk1 B.11.31 U ia64 3548698697 unlimited-user license
DB: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
完整的addmrpt报告和参数分别在附件中,

下面是操作系统virtual memory page size：
[oracle@xxx1]:BOSDB1:/home/oracle$ /usr/bin/chatr $ORACLE_HOME/bin/oracle
/oracle/products/11.2.0/bin/oracle:
      64-bit ELF executable
      shared library dynamic path search:
         LD_LIBRARY_PATH enabled  first
         SHLIB_PATH       enabled  second
         embedded path    enabled  third  /oracle/products/11.2.0/rdbms/lib/:/oracle/products/11.2.0/lib/:/oracle/products/11.2.0/ctx/lib/:/usr/lib/hpux64:/opt/langtools/lib/hpux64
      shared library list:
         libodm11.so
         libcell11.so
         libskgxp11.so
         libnnz11.so
         libclsra11.so
         libdbcfg11.so
         libhasgen11.so
         libskgxn2.so
         libocr11.so
         libocrb11.so
         libocrutl11.so
         librt.so.1
         libdl.so.1
         libm.so.1
         libpthread.so.1
         libnsl.so.1
         libunwind.so.1
         libdiskown.so
         libc.so.1
      shared library binding:
         deferred
      global hash table disabled
      global hash table size 1103
      shared library mapped private disabled
      runtime checks disabled
      shared library segment merging disabled
      shared vtable support disabled
      explicit unloading disabled
      linkage table protection disabled
      segments:
         index type    address    flags size
               8 text 4000000000000000 z---c-  16M
               9 data 6000000000000000 ---m-- L (largest possible)
      executable from stack: D (default)
      kernel assisted branch prediction enabled
      lazy swap allocation for dynamic segments disabled
      nulptr dereferences trap disabled
      address space model: default
      caliper dynamic instrumentation disabled
最后不确定还需要提供什么内容。

最后补发了另一对相对应的awrrpt和addm rpt,文件。