Re: DB Block Size in Linux

From: Rick Denoire <100.17706_at_germanynet.de>
Date: Tue, 13 Jan 2004 23:24:14 +0100
Message-ID: <jsr8009e3419jnccmq0mu0qql2p5sg7h2r@4ax.com>

toby_brown_at_optusnet.com.au (Toby Brown) wrote:

>Then creating an Oracle9i database with a db block size larger than 4k
>(e.g. 8k) shouldn't be a problem since the filesystem buffer cache
>would cache a multiple of the filesystem blocks, in this case, a
>multiple of 4k blocks, meaning that an 8k database block size wouldn't
>induce any additional IO (behind the scenes) as I had feared before.

Painfully enough, it is not possible to mount ext3 filesystems unbuffered in Linux. You will always have double buffering (except with raw devices of course).

Bye
Rick Denoire Received on Tue Jan 13 2004 - 16:24:14 CST