alter日志报WARNING: Heavy swapping observed on system in last 5 mins.

jiawang

alter日志报错现象：
Thu Sep 28 21:51:27 2023
WARNING: Heavy swapping observed on system in last 5 mins.
pct of memory swapped in [2.95%] pct of memory swapped out [6.32%].
Please make sure there is no memory pressure and the SGA and PGA
are configured correctly. Look at DBRM trace file for more details.

在11gR2中DBRM(database resource manager，11gR2中新的后台进程，会在Alert.log告警日志中反映OS操作系统最近5分钟是否有剧烈的swap活动了。

        可以看到dbrm收集到了短期内的swapin和swapout数据，这样便于我们诊断由swap造成的性能或者hang问题。
matelink上面相关的文章截取：

        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.

             上面的方法就是打补丁或做升级。但是具体问题还是得具体解决，要结合自己的情况。

     我的库的版本是： 11.2.0.4.0已经高于上面所说的，所以可以排除升级或打补丁操作。
通过对自己库的了解，我认为我的不需要打补丁或者升级。