WARNING: Heavy swapping observed on system in last 5 mins
In alert log. getting the following WARNING: Heavy swapping observed on system in last 5 mins.
WARNING: Heavy swapping observed on system in last 5 mins.
Heavy swapping can lead to timeouts, poor performance, and instance eviction.
Errors in file E:\ORACLE\diag\rdbms\ic\ic\trace\ic_dbrm_5436.trc (incident=24027):
ORA-00700: soft internal error, arguments: [kskvmstatact: excessive swapping observed], , , , , , , , , , , 
Incident details in: E:\ORACLE\diag\rdbms\ic\ic\incident\incdir_24027\ic_dbrm_5436_i24027.trc
Until Oracle 22.214.171.124 version doesn’t report any swap warning in the alert.log.
For 126.96.36.199 and 188.8.131.52, a warning for swapping is written to the alert.log by the fix of unpublished Bug 10220118 – NEED TO ALERT WHEN SYSTEM IS CLOSE TO PAGING.
With 12.1.0.X, Oracle writes the warning and adds more diagnostic information with the ORA-700 error
If the total swap in + swap out percentage is over a certain threshold (2%).
Warning is generated in alert log when Oracle sees that the amount of memory swapped is greater than 2% of the physical memory in the past 5 minutes.
1. Solutions are to reduce the amount of SGA memory by reducing the MEMORY_TARGET or SGA_TARGET and PGA_AGGREGATE_TARGET parameters. If it exceed from Physical memory of your Server.
Oracle allocate Memory = SGA_TARGET + PGA_AGGREGATE_TARGET
2. In Oracle the alert log message warning and ORA-700 are expected behavior for 12c, no action is required.
For remove the message from alert log. you can apply the fix 23104033:
184.108.40.206.190115 (Jan 2019) Database Jan 2019 Release Update (DB RU)
220.127.116.11.180531 (May 2018) Bundle Patch for Windows Platforms