This discussion is archived
5 Replies Latest reply: May 8, 2012 2:16 AM by 840710 RSS

Out of memory problem after upgrade from 10.2.0.5 to 11.2.0.3

840710 Newbie
Currently Being Moderated
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 11.2.0.3 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

Legend

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