ADDM Reports bug:Significant virtual memory paging was detected on the host operating system

简介:

查看ADDM(数据库版本为ORACLE 10.2.0.5.0)报告时,发现其中有个结论非常不靠谱:Significant virtual memory paging was detected on the host operating system,具体内容如下所示:

FINDING 2: 100% impact (3930 seconds)
-------------------------------------
Significant virtual memory paging was detected on the host operating system.
 
   RECOMMENDATION 1: Host Configuration, 100% benefit (3930 seconds)
      ACTION: Host operating system was experiencing significant paging but no
         particular root cause could be detected. Investigate processes that
         do not belong to this instance running on the host that are consuming
         significant amount of virtual memory. Also consider adding more
         physical memory to the host.

clip_image001

使用nmon监控并没有发现消耗大量虚拟内存(virtual memory),搜索了一下,发现这个是一个bug导致。ORACLE 10g, ORACLE 11都有出现这个问题.

clip_image002

官方ADDM Reports Significant Virtual Memory Paging on Linux When None is Occurring (文档 ID 1322964.1)介绍如下所示

 

SYMPTOMS

After upgrading the database to 10.2.0.5, the ADDM report on Linux operation system may include findings on "Significant virtual memory paging":



FINDING 1: 100% impact (32719 seconds)
--------------------------------------
Significant virtual memory paging was detected on the host operating system.

RECOMMENDATION 1: Host Configuration, 100% benefit (32719 seconds)
ACTION: Host operating system was experiencing significant paging but 
no particular root cause could be detected. Investigate processes that
do not belong to this instance running on the host that are 
consuming significant amount of virtual memory. Also consider adding more
physical memory to the host.


There is no evidence at OS level of any problem with virtual memory paging. To verify that you are not really observing a memory problem, look at an operating system memory tool, such as vmstat:


Note: Under swap, si and so show a value of 0.
As above, if there are no abnormal figures and you are still seeing this warning, you might me hitting this problem

 

 

CAUSE

This issue can be seen from 10.2.0.5 to 11.2.0.2


The problem is caused by wrong values in V$OSSTAT as explained in:
Bug 10148787  ADDM REPORTS VIRTUAL MEMORY PAGING AFTER APPLYING 10.2.0.5 
and unpublished 
Bug 11712010   VIRTUAL MEMORY PAGING ON 11.2.0.2 DATABASES. 

ORACLE 10.2.0.5 可以通过下载补丁补丁程序12347332: TRACKING BUG TO FIX ADDM INCORRECTLY REPORTING PAGING ON 10.2.0.5解决这个Bug

相关文章
|
9月前
|
运维 监控 网络协议
译|llustrated Guide to Monitoring and Tuning the Linux Networking Stack: Receiving Data
译|llustrated Guide to Monitoring and Tuning the Linux Networking Stack: Receiving Data
72 0
|
9月前
|
缓存 监控 网络协议
译|Monitoring and Tuning the Linux Networking Stack: Receiving Data(九)
译|Monitoring and Tuning the Linux Networking Stack: Receiving Data(九)
208 0
|
9月前
|
监控 Linux
译|Monitoring and Tuning the Linux Networking Stack: Receiving Data(一)
译|Monitoring and Tuning the Linux Networking Stack: Receiving Data
107 0
|
9月前
|
监控 Linux 数据处理
译|Monitoring and Tuning the Linux Networking Stack: Receiving Data(四)
译|Monitoring and Tuning the Linux Networking Stack: Receiving Data(四)
74 0
|
9月前
|
缓存 监控 Ubuntu
译|Monitoring and Tuning the Linux Networking Stack: Receiving Data(七)
译|Monitoring and Tuning the Linux Networking Stack: Receiving Data(七)
68 0
|
9月前
|
存储 缓存 监控
译|Monitoring and Tuning the Linux Networking Stack: Receiving Data(六)
译|Monitoring and Tuning the Linux Networking Stack: Receiving Data(六)
82 0
|
9月前
|
缓存 监控 网络协议
译|Monitoring and Tuning the Linux Networking Stack: Receiving Data(三)
译|Monitoring and Tuning the Linux Networking Stack: Receiving Data(三)
166 0
|
9月前
|
监控 Ubuntu Linux
译|Monitoring and Tuning the Linux Networking Stack: Receiving Data(二)
译|Monitoring and Tuning the Linux Networking Stack: Receiving Data(二)
63 0
|
9月前
|
监控 Linux 数据处理
译|Monitoring and Tuning the Linux Networking Stack: Receiving Data(五)
译|Monitoring and Tuning the Linux Networking Stack: Receiving Data(五)
48 0
|
9月前
|
缓存 监控 网络协议
译|Monitoring and Tuning the Linux Networking Stack: Receiving Data(八)
译|Monitoring and Tuning the Linux Networking Stack: Receiving Data(八)
44 0