Re: NT block size

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Fri, 10 Dec 1999 14:21:06 GMT
Message-ID: <38510C52.380FEB6D@edcmail.cr.usgs.gov>

Robert Fazio wrote:
>
> Oracle's default block size is 2k, and it is supported on NT. Your choice
> should be based upon your database needs, and not the OS.

Only partially true. While the database needs are the biggest factor in determining the Oracle block size, you should make the Oracle block size an integer multiple of the OS block size. So the OS block size does factor into your plans. If the OS block size is 4K and you let the Oracle block size default to 2k, you will run into performance problems. When reading two consecutive 2k blocks, the OS will actually read the 4K block twice.

HTH,
Brian Received on Fri Dec 10 1999 - 08:21:06 CST