Re: Linux Memory Accounting

  • From: "Christo Kutrovsky" <kutrovsky.oracle@xxxxxxxxx>
  • To: jkstill@xxxxxxxxx
  • Date: Wed, 4 Oct 2006 13:18:00 -0400

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/


On 10/3/06, Jared Still <jkstill@xxxxxxxxx> wrote:
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/
--
http://www.freelists.org/webpage/oracle-l


Other related posts: