This discussion is archived
0 Replies Latest reply: Apr 10, 2013 7:40 PM by 879831 RSS

High page ins/sec with high Address Translation Page Faults/sec

879831 Newbie
Currently Being Moderated
Hi All,

I was thinking this is more relating to operating system category that's why I'm posting here although this host is running an Oracle database 10g.

as stated, it is a Solaris 64bit host serving Oracle database 10g with approx 1000 sessions connected all the time. 96GB physical ram with 32 sparc CPUs. Oracle SGA+PGA size is around 40GB.

sympton 1: high page ins/sec
[https://dl.dropboxusercontent.com/u/31238593/memory%20report.jpg]

sympton 2: high Address Translation Page Faults rate
[https://dl.dropboxusercontent.com/u/31238593/oem%20paging%20activity.jpg]

sympton 3: memory/swap utilisation
[https://dl.dropboxusercontent.com/u/31238593/oem_mem_util.jpg]

Questions are:
Is high page ins relating to high address translation page faults?

What are the possible causes of them?

Is this impacing performance of database running on the host?


Thanks

Legend

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