0 Replies Latest reply: Apr 10, 2013 9:40 PM by 879831 RSS

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

    879831
      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