Re: db_block_size and performance

From: Chuck Hamilton <chuckh_at_safeaccess.net>
Date: Thu, 29 Oct 1998 08:20:20 -0500
Message-ID: <36386B93.D8084657@safeaccess.net>

> There is no hard and fast rule about how big a db_block_size to use. It
> depends on your application.

Actually there is one hard and fast rule -- make sure the block size is a multiple of the OS block size. Otherwise you'll end up issuing multiple OS calls to read the same physical block of data.

We had an OLTP Oracle database running on Netware. It was installed with the default 2k block size even though the OS block size was 8k. We increased the DB block size to 8k and saw a significant performance increase.

Chuck Hamilton

application/x-pkcs7-signature attachment: S/MIME Cryptographic Signature

Received on Thu Oct 29 1998 - 07:20:20 CST