Last updated on AUGUST 10, 2017
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 to 18.104.22.168 [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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms