Re: Linux Memory Accounting

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_at_gmail.com> wrote:


> 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

>

>



-- 
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