Re: Linux Memory Accounting

From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 3 Oct 2006 14:57:31 -0700
Message-ID: <bf46380610031457q3a589aabr4950a94b93fb0c2a@mail.gmail.com>

Hi Frits,

Comments inline:

On 10/3/06, Frits Hoogland <frits.hoogland_at_gmail.com> 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

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Oct 03 2006 - 16:57:31 CDT