Hey Jared, I'll have to check this out (may help with new ERP go-live), but you seem to imply that this accounting issue is only an issue on Linux. This isn't the case for HP-UX, Solaris, and AIX? I can't say I've treated it any other way, although I can only recall needing to look at this info once before... Rich ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jared Still Sent: Tuesday, October 03, 2006 4:58 PM To: Frits Hoogland Cc: Oracle-L Freelists Subject: Re: Linux Memory Accounting Hi Frits, Comments inline: On 10/3/06, Frits Hoogland <frits.hoogland@xxxxxxxxx> wrote: this means it's impossible to calculate database memory usage in a simple way by examining the processes at OS level. Yes, I've discovered that. so I'd go with kevin's recommandation to use some tool to look at global OS level to see memory usage. besides the omitted shared memory, it's accurate. I've cobbled together a script to scan the /proc/<PID>/maps files for a process owner, and add up the memory, hopefully with a minimum of double counting. The results for running it on 2 servers are approximately what I would expect to see. This includes shared memory. http://jaredstill.com/downloads/proc_mem_used.tgz Comments, suggestions and/or improvments are welcomed. -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist