Re: linux memory settings on OL 6.2 ( red hat compatible )

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Mon, 10 Sep 2012 18:58:49 +0000 (UTC)
Message-ID: <pan.2012.09.10.18.58.48_at_gmail.com>



On Mon, 10 Sep 2012 01:16:14 -0700, Matthias Hoys wrote:

> Mladen,
>
> Are there any tools to measure/tune the performance impact of these VM
> subsystem settings? Do you have any idea what the performance gain can
> be on a optimal configured system with Oracle running on it?
>
> Thanks,
> Matthias http://matthiashoys.wordpress.com

Mathias, the only tools available are the Linux tools that measure the consumption of Linux resources. Those are the usual suspects: top, sar, iostat, vmstat, dstat, atop and iotop, the last one being available only on RH 6.x kernels.
I was solving problems on case by case basis and it has always included other things as well, like using direct IO, putting the database on ASM and alike. Those, however, are palliative measures and I would be unwilling to attribute any significant savings to them. I still have to play with chrt and make LGWR a real-time process to see whether that makes any palpable difference.
As a holistic, soul searching measures, setting this parameters makes sense, at least in my eyes, despite the fact that I don't have any numbers to back my advice.

-- 
Mladen Gogala
http://mgogala.freehostia.com
Received on Mon Sep 10 2012 - 13:58:49 CDT

Original text of this message