AIX6.1/11.2.0.3数据库上关于SWAP的一个BUG

昨天去南京某客户那里调优新上线的业务数据库，在查看alert.log日志时发现在过去的一段时间里，每过几个小时或间隔一段时间，就会报类似以下的内容：

Thu Aug 21 09:01:26 2014

WARNING: Heavy swapping observed on system in last 5 mins.

pct of memory swapped in [8.42%] pct of memory swapped out [2.16%].

Please make sure there is no memory pressure and the SGA and PGA

are configured correctly. Look at DBRM trace file for more details.

Thu Aug 21 14:56:27 2014

WARNING: Heavy swapping observed on system in last 5 mins.

pct of memory swapped in [5.40%] pct of memory swapped out [8.63%].

Please make sure there is no memory pressure and the SGA and PGA

are configured correctly. Look at DBRM trace file for more details.

......

Sat Oct 18 22:13:48 2014

WARNING: Heavy swapping observed on system in last 5 mins.

pct of memory swapped in [7.76%] pct of memory swapped out [0.33%].

Please make sure there is no memory pressure and the SGA and PGA

are configured correctly. Look at DBRM trace file for more details.

客户的环境是IBM P570，AIX 6.1，安装了Oracle 11.2.0.3单实例数据库，物理内存64G，仅仅分配了20G给SGA，采用memory自动管理

查阅了一下MOS，发现是AIX平台上的一个bug，相关文档为：[1508575.1]

对应的数据库和平台：

Oracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.3 [Release 11.2]

IBM AIX on POWER Systems (64-bit)

症状：

There is new warning message in alert.log in 11.2.0.3 similar to

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

On AIX pla