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

sympton 2: high Address Translation Page Faults rate

sympton 3: memory/swap utilisation

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?



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