This discussion is archived
4 Replies Latest reply: Sep 26, 2012 3:30 AM by MahirM.Quluzade RSS

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

karmaya Newbie
Currently Being Moderated
i am using oracle 11.2.0.2.0 version.i am facing below issue in my DB.

WARNING: Heavy swapping observed on system in last 5 mins.
pct of memory swapped in [6103708.75%] pct of memory swapped out [6612393.29%].
Please make sure there is no memory pressure and the SGA and PGA
are configured correctly. Look at DBRM trace file for more details.

my DB SGA Size:
sga_max_size big integer 2G
sga_target big integer 0

memory :
MEMORY_TARGET=2048M
memory_max_target=2560M

but still i am getting the issue. how can i fix this issue.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points