Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Linux Memory Accounting

RE: Linux Memory Accounting

From: Jesse, Rich <Rich.Jesse_at_qg.com>
Date: Wed, 4 Oct 2006 12:05:03 -0500
Message-ID: <FB5D3CCFCECC2948B5DCF4CABDBE6697A522B7@QTEX1.qg.com>


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
Received on Wed Oct 04 2006 - 12:05:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US