RE: Linux Memory Accounting

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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_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