Jared,
I am working on a presentation that will answer these exact questions. I have the abstract here:
http://www.pythian.com/blogs/255/the-answer-to-free-memory-swap-oracle-and-everything
-- Christo Kutrovsky Senior Database/System Administrator The Pythian Group - www.pythian.com I blog at http://www.pythian.com/blogs/
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
-- Christo Kutrovsky Senior Database/System Administrator The Pythian Group - www.pythian.com I blog at http://www.pythian.com/blogs/ -- //www.freelists.org/webpage/oracle-l