RE: Linux Memory Accounting

  • From: "Jesse, Rich" <Rich.Jesse@xxxxxx>
  • Date: Wed, 4 Oct 2006 12:05:03 -0500

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


Other related posts: