Re: high memory used sessions

From: <J.Velikanovs_at_alise.lv>
Date: Wed, 22 Sep 2004 09:23:08 +0300
Message-ID: <OFCEB86DDA.178220DA-ONC2256F17.0022B85E-C2256F17.00232E24@alise.lv>

If you able to get 100GB RAM on Sun, try to get a little bit time and read:
http://www.sun.com/sun-on-net/performance/vmsizing.pdf Possible, then you will sell 1/2 of RAM, because your not using it anyway :)

On 09.09.2004 13:28:15 oracle-l-bounce wrote:

>Dinesh,
>I would like to recommend you to read this paper:
>http://www.sun.com/sun-on-net/performance/vmsizing.pdf
>
>This document explains a lot about Unix memory structures architecture
and
>tools you can use to diagnose issues.
>Whiten by Sun, but apply to any UNIX platform.
>
>To get quicker to solution, On Solaris platform try /usr/proc/bin/pmap
><pid>
>
>Jurijs

Jurijs
+371 9268222 (+2 GMT)

Thank you for teaching me.
http://otn.oracle.com/ocm/jvelikanovs.html

"Kommareddy, Srinivas (GE Healthcare, non-ge)" <Srinivas.Kommareddy_at_med.ge.com>
Sent by: oracle-l-bounce_at_freelists.org
22.09.2004 09:00
Please respond to Srinivas.Kommareddy

        To:     <oracle-l_at_freelists.org>
        cc: 
        Subject:        high memory used sessions

Hi all,

OS: solaris 5.9

We have some issues with the high memory usage on solaris box sometimes.

The top command returns the following:

last pid: 27551; load averages: 4.98, 4.38, 4.71 05:51:32
426 processes: 415 sleeping, 4 zombie, 7 on cpu CPU states: 40.3% idle, 20.6% user, 9.0% kernel, 30.1% iowait, 0.0% swap
Memory: 64G real, 44G free, 10G swap in use, 50G swap free

Sometimes, I see the free memory is very less, say 100 M or so...

How to find out which sessions are using high memory.

I can see the sessions which are using high cpu,

PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND

  7447 oracle     1   0    0 8178M 8144M sleep   44:44  1.92% oracle
 28974 oracle     1  30    0 8089M 8055M sleep  108:51  1.57% oracle
  6447 oracle     1  40    0 8079M 8044M sleep    1:06  0.91% oracle
 16648 oracle     1  31    0 8165M 8121M sleep  524:28  0.76% oracle

but how to find which OS thread is using more memory. (because I have several databases on one box and I cant see login and check in each db )

Could anybody throw somelight on this.

Thanks in advance,
Srinivas

--
http://www.freelists.org/webpage/oracle-l



--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 22 2004 - 01:19:57 CDT