Re: ORACLE on Linux - IO bottleneck

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Fri, 10 Feb 2006 12:45:16 GMT
Message-Id: <pan.2006.02.10.12.45.16.752670@sbcglobal.net>

On Thu, 09 Feb 2006 15:14:20 +0100, Fabrizio Magni wrote:

> The second dd has its I/O merged.
>
> Consider this controversial but the I/O scheduler eliminate the need to
> have oracle block size "aligned" to file system block size (even without
> direct I/O).
>
> Regards

How exactly did you test? Did you use elvtune (RH3) or did you put an appropriate scheduler in grub.conf (RH4)? This is a very special case of a sequential I/O which doesn't tell you much. Usually, I/O patterns resulting from the database use are a bit different.

-- 
http://www.mgogala.com

Received on Fri Feb 10 2006 - 06:45:16 CST