12c: Warning Message About Heavy Swapping Observation and ORA-700 [kskvmstatact: excessive swapping observed]
Last updated on DECEMBER 19, 2017
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 to 184.108.40.206 [Release 12.1 to 12.2]
Oracle SuperCluster M7 Hardware - Version All Versions to All Versions [Release All Releases]
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms