WARNING:Heavyswappingobservedonsysteminlast5mins


        客户的环境是Oracle Database 11.2.0.3 for IBM AIX,在告警日志中查看到如下信息:
Fri May 03 23:22:47 2013
WARNING: Heavy swapping observed on system in last 5 mins.
pct of memory swapped in [3.54%] pct of memory swapped out [8.73%].
Please make sure there is no memory pressure and the SGA and PGA
are configured correctly. Look at DBRM trace file for more details.

METALINK文章描述如下:

WARNING: Heavy Swapping Observed On System In Last 5 Mins.After upgrade to 11.2.0.3 [ID 1452790.1]
修改时间:2013-3-2WARNING: Heavy swapping observed on system in last 5 mins类型:HOWTOWARNING: Heavy swapping observed on system in last 5 mins状态:PUBLISHEDWARNING: Heavy swapping observed on system in last 5 minsWARNING: Heavy swapping observed on system in last 5 mins优先级:3

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Goal

The document explains why you may see the following WARNING in the alert log after upgrading to 11.2.0.3.

创新互联公司-成都网站建设公司,专注成都网站建设、网站设计、网站营销推广,域名注册,网络空间,网站托管、服务器租用有关企业网站制作方案、改版、费用等问题,请联系创新互联公司

Wed Apr 25 10:10:50 2012
WARNING: Heavy swapping observed on system in last 5 mins.
pct of memory swapped in [7.16%] pct of memory swapped out [0.56%].
Please make sure there is no memory pressure and the SGA and PGA
are configured correctly. Look at DBRM trace file for more details.

Fix

The reason you may now see these informational messages in the alert is due to the fact that in 11.2.0.3 an enhancement fix was included for unpublished
Bug 10220118 - Print warning to alert log when system is swapping (Doc ID 10220118.8)

Please refer to
Note 10220118.8 - Bug 10220118 - Print warning to alert log when system is swapping



Description

  This fix is really an enhancement.
  With this fix a warning is printed to the alert log (and DBRM trace)
  if excessive swapping is observed on the system.
  The warning will not be printed more than once per hour.
  

The same issues could have been happening on 11.2.0.2 but they simply would not have been reported.
There is no cause for concern and we suggest that the databases are just monitored as usual.

If you look in the alert log, you will see that the message does not happen every hour. 
If SWAP was causing any serious issue we could also see ORA-4031/ORA-4030 and would then be able to use the DBRM trace in conjunction with obtaining further diagnostics.

 

- If your Platform. is IBM-AIX then This is not the only reason for this alert log file. There is a known port-specific bug for IBM AIX on POWER Systems (64-bit):

Bug 14731911 : FALSE SWAP WARNING MESSAGES PRINTED TO ALERT.LOG ON AIX
Base Bug 11801934 : WRONG PAGE-IN AND PAGE-OUT OS VM STATS IN AIX.

Solution for AIX

Apply patch 11801934 if available for your platform. or request a patch to Oracle Support in a new Service Request.

 

11801934补丁的下载地址是:https://updates.oracle.com/download/11801934.html

--end--



网站名称:WARNING:Heavyswappingobservedonsysteminlast5mins
文章链接:http://bzwzjz.com/article/jggsgs.html

其他资讯

Copyright © 2007-2020 广东宝晨空调科技有限公司 All Rights Reserved 粤ICP备2022107769号
友情链接: 成都响应式网站建设公司 成都网站制作 成都网站建设推广 成都网站制作 重庆网站制作 定制网站设计 网站制作 成都营销网站制作 网站设计 成都网站建设 成都网站制作 手机网站建设 企业网站建设 成都网站建设 营销型网站建设 成都网站设计 成都网站建设公司 网站设计 外贸网站设计方案 成都网站建设 成都网站设计 成都网站建设