Re: What is a good blocksize to use.

From: <kennethkoenraadt_at_no-spam.hotmail.com>
Date: Tue, 24 Sep 2002 17:49:39 GMT
Message-ID: <3d90a37f.563660@news.mobilixnet.dk>

On Tue, 24 Sep 2002 14:37:33 GMT, benbrugman_at_onbekend.nl (Ben Brugman) wrote:

>For a transactional machine, where most rows contain a few hundred
>byte. Assume a RAID (1/0) device as storage medium.
>
>What is a good blocksize, and why ?

Oracle 9.2 offers blocksizes of 2, 4, 8, 16 and 32 K.

The little information you provide ( small rows and many transactions) point to a block size in the lower range. Furthermore, your block size should be equal to or a multiple of the O/S block size.

Kenneth Koenraadt

>
>What are the effects of going smaller in blocksize ?
>What are the effects of going larger in blocksize ?
>
>ben brugman
>Ben Brugman
Received on Tue Sep 24 2002 - 12:49:39 CDT