Re: Solaris 10/Oracle 9 memory problems - but I can't see why ...
From: <fightphotos_at_googlemail.com>
Date: Wed, 22 Apr 2009 05:45:14 -0700 (PDT)
Message-ID: <69d4c569-9848-4de6-a1ea-11dcdab3741f_at_e14g2000vbe.googlegroups.com>
On Apr 20, 3:26 pm, Neil Cudd <neil.c..._at_blueyonder.co.uk> wrote:
> 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
Date: Wed, 22 Apr 2009 05:45:14 -0700 (PDT)
Message-ID: <69d4c569-9848-4de6-a1ea-11dcdab3741f_at_e14g2000vbe.googlegroups.com>
On Apr 20, 3:26 pm, Neil Cudd <neil.c..._at_blueyonder.co.uk> wrote:
> 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
DBAs should avoid tampering with UNIX.
Danny. Received on Wed Apr 22 2009 - 07:45:14 CDT