Re: high memory used sessions

  • From: J.Velikanovs@xxxxxxxx
  • Date: Wed, 22 Sep 2004 09:23:08 +0300

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@xxxxxxxxxx>
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
22.09.2004 09:00
Please respond to Srinivas.Kommareddy
 
        To:     <oracle-l@xxxxxxxxxxxxx>
        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

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



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

Other related posts: