high memory used sessions
- From: "Kommareddy, Srinivas (GE Healthcare, non-ge)" <Srinivas.Kommareddy@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 22 Sep 2004 01:00:34 -0500
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
Other related posts:
