Re: Oracle block size - OS block size

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam>
Date: Thu, 14 Jun 2001 11:41:27 GMT
Message-ID: <3b28a08c.4392994@news-server>

On Thu, 14 Jun 2001 09:44:20 +0200, John van Eck <JvanEck_at_ssc.dordrecht.nl> wrote:

>I have found disk blocks to be 512 bytes.

John, *ALL* SCSI disks in the world have 512 "block" size. It's actually called the sector size and is fixed and a part of the SCSI standard, can't be changed. Call it a hardware thing. Of course, file systems at the OS level will use a different size. Which will *always* be a multiple of 512.

>I have also found with the
>command df -g the value of 8192 for the file system block size.

That's the one to use for your database. Set db block size to 8K and you won't regret it ever.

Cheers
Nuno Souto
nsouto_at_bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Thu Jun 14 2001 - 06:41:27 CDT