Hello All,
I am using Oracle 11gR2 on AIX 7.1.
I am seeing the below warning in my alert log file:
WARNING: Heavy swapping observed on system in last 5 mins.
pct of memory swapped in [187.54%] pct of memory swapped out [0.81%].
Please make sure there is no memory pressure and the SGA and PGA
are configured correctly. Look at DBRM trace file for more details.
My available RAM on the OS is 13.5 G and I configured the swap space to be 1.5 times the RAM, approximately 20G as recommended by Oracle.
My memory target is 6G.
1. First how could I look to the DBRM trace?
2. If my OS RAM is 13.5 G how much can I maximum increase my memory target ? I putted approximately to 40%~ 45% of total RAM
3. What action should be taken to resolve the above mentioned warning?
Regards,