high memory used sessions

From: Kommareddy, Srinivas (GE Healthcare, non-ge) <Srinivas.Kommareddy_at_med.ge.com>
Date: Wed, 22 Sep 2004 01:00:34 -0500
Message-ID: <7DF59EAC75A1F145A1F6E9574220257EC56646@MKEMLVEM07.e2k.ad.ge.com>

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

Received on Wed Sep 22 2004 - 00:55:50 CDT