0 Replies Latest reply on Apr 11, 2013 2:40 AM by Hsin

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

      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?