Hi Frits,
Comments inline:
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.
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