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

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.

Error
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

Cause
Until Oracle 11.2.0.3 version doesn’t report any swap warning in the alert.log.
For 11.2.0.3 and 11.2.0.4, 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.

Solution
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:
18.1.0
12.2.0.1.190115 (Jan 2019) Database Jan 2019 Release Update (DB RU)
12.2.0.1.180531 (May 2018) Bundle Patch for Windows Platforms

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.