5 Replies Latest reply: May 8, 2012 4:16 AM by 840710 RSS

    Out of memory problem after upgrade from to

      Hi All,

      I am getting out of memory problem frequently in in Alert log. Below are my findings:

      1) There are total 10 instances running on my sun solaris server 10. So as per oracle installation document max-shm-memory is 4294967295 and in my server it has 34359738368.

      2) All instances are upgraded to recently and their SGA are set to 1570471936 bytes.

      3) Shared pool size is 600M and DB_CACHE_SIZE is 60M.

      ORA error is (incident=4685):~ORA-04031: unable to allocate 36424 bytes of shared memory ("shared pool","unknown object","sga heap(1,1)","krbmror")

      Can you please suggest what parameter do I need to change to get rid of this error.

      Advance thanks.

      Edited by: user7280060 on May 8, 2012 11:59 AM