Re: OS block size vs. DB block size

If you use raw disks, you must use 512 or multiples thereof. 512 is the standard physical block size for SCSI disks and ORACLE will be talking to disks with raw data files.

If you use the UNIX file system, then you may use the file system block size. This used to be 2k, but in later versions of UNIX it has increased, although in most cases you can still specify at file system creation time the block size you want.

Note that even with the UNIX file system, the block size is still a multiple of 512 and that is due to the prevalent use of SCSI disk devices in UNIX.

HTH
Cheers
Nuno Souto
nsouto_at_acay.com.au

S S Wan wrote:

> Hello all,
>
> I was confused by the documents from SUN. They said
> that the logical filesystem block size is 8192 bytes but
> the physical block size is 512 bytes. My concern is which
> figure I should take to consider the DB block size, which
> should be integral multiple of the OS block size.
>
> Does anyone have insight?
Received on Fri Mar 27 1998 - 00:00:00 CST