12c: Warning Message About Heavy Swapping Observation and ORA-700 [kskvmstatact: excessive swapping observed]
(Doc ID 1919850.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle SuperCluster M7 Hardware - Version All Versions to All Versions [Release All Releases]
Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199 [Release 12.1 to 12.2]
Information in this document applies to any platform.
Alert log reports frequent information about memory being swapped like below:
WARNING: Heavy swapping observed on system in last 5 mins.
pct of memory swapped in [2.70%] pct of memory swapped out [0.00%].
Please make sure there is no memory pressure and the SGA and PGA
are configured correctly. Look at DBRM trace file for more details.
Errors in file /orasw01/oracle/diag/rdbms/elfadev/ELFADEV/trace/ELFADEV_dbrm_21092.trc (incident=16909):
ORA-00700: soft internal error, arguments: [kskvmstatact: excessive swapping observed], , , , , , , , , , , 
Incident details in: /orasw01/oracle/diag/rdbms/elfadev/ELFADEV/incident/incdir_16909/ELFADEV_dbrm_21092_i16909.trc
The sum of the pct memory swapped in and swapped out always appears to be higher that 2%.
The DBRM trace file shows information similar to:
Heavy swapping observed in last 5 mins: [pct of total memory][bytes] total swpin [ 3.60%][599496K], total swpout [ 0.00%][0K] vm stats captured every 30 secs for last 5 mins: swpin: swpout: [ 0.07%][ 12416K] [ 0.00%][ 0K] [ 0.38%][ 63712K] [ 0.00%][ 0K] [ 0.05%][ 9432K] [ 0.00%][ 0K] [ 0.81%][ 135488K] [ 0.00%][ 0K] [ 0.35%][ 59032K] [ 0.00%][ 0K] [ 0.22%][ 37744K] [ 0.00%][ 0K] [ 0.35%][ 58544K] [ 0.00%][ 0K] [ 0.62%][ 104592K] [ 0.00%][ 0K] [ 0.56%][ 93368K] [ 0.00%][ 0K] [ 0.15%][ 25168K] [ 0.00%][ 0K] Heavy swapping observed in last 5 mins: [pct of total memory][bytes]
The call stack trace is similar to
... kskvmstatact kskdbrmtoutact ksbcti ksbabs ksbrdp opirip opidrv sou2o ...
Upgraded to version 12.1.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!