Solaris 10/Oracle 9 memory problems - but I can't see why ...

From: Neil Cudd <neil.cudd_at_blueyonder.co.uk>
Date: Mon, 20 Apr 2009 07:26:31 -0700 (PDT)
Message-ID: <fff10193-f877-488d-a416-db678db0c45e_at_l9g2000vba.googlegroups.com>



Hello,

Solaris sparc 5.10 running Oracle 9.2.0.764 bit EE. The server has 2Gb physical memory.
The (offshore) unix monitors are telling me the server is running out of memory. They won't tell me anything else. I guess they think that'd take the fun out of it.
There is one oracle instance with a total sga of 380Mb There isn't anything else running (other than BMC Patrol and a Java process).
My unix skills are shaky, but prstat gives the following (editied for highlights) :

   PID USERNAME SIZE RSS STATE PRI NICE TIME CPU PROCESS/ NLWP
  1104 patrol 42M 36M cpu0 0 10 3:19:43 1.1% PatrolAgent/ 1

  3035 oracle    456M  437M sleep   59    0   0:02:39 0.0% oracle/12
  3098 patrol    450M  444M sleep   59    0   0:11:19 0.0% oracle/1
  3097 patrol     18M   10M sleep   59    0   0:04:27 0.0% sqlplus/1
  3047 oracle    456M  438M sleep   59    0   0:00:02 0.0% oracle/11
  3037 oracle    452M  434M sleep   59    0   0:02:08 0.0% oracle/12
  3031 oracle    450M  429M sleep   59    0   0:01:44 0.0% oracle/1
  3043 oracle    449M  433M sleep   59    0   0:00:39 0.0% oracle/1
  3045 oracle    449M  437M sleep   59    0   0:00:37 0.0% oracle/1

A couple of questions :
Is this output saying that each of those oracle processes has 400+Mb memory allocated to it (can't be surely..) Is there anything anyone can suggest to identify just what is eating all the memory ?

Many thanks for any advice,
Neil Received on Mon Apr 20 2009 - 09:26:31 CDT

Original text of this message