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