Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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-lReceived on Wed Sep 22 2004 - 00:55:50 CDT
![]() |
![]() |