Re: DB Block size and JFS2

From: Matthias Hoys <anti_at_spam.com>
Date: Fri, 3 Mar 2006 23:40:42 +0100
Message-ID: <4408c5eb$0$2135$ba620e4c@news.skynet.be>

<DMina_at_laiki.com> wrote in message
news:1141386801.249704.212010_at_e56g2000cwe.googlegroups.com...
> Hello people,
>
> I would like here to ask you something about Oracle from the DBA point
> of view if you don't mind.
>
> The issue has to do with the Oracle DB_BLOCK_SIZE. (i am referring
> specifically to AIX, but i think it applies to other OS also)
> Based on the documentation i read so far i came to the following
> conclusion:
>
> If you are going to use JFS2 with CIO option then your DB_BLOCK_SIZE
> should match the filesystem block size of your OS (in our case this is
> equal to 4K).

Correct, but I believe for redo log files, you should use 512bytes fs block size.

Matthias Received on Fri Mar 03 2006 - 16:40:42 CST