Re: What is a good blocksize to use.

Ben Brugman <benbrugman_at_onbekend.nl> 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 ?

Depends mostly on the storage configuration, and the OS.

http://www.ixora.com.au/tips/buffered_block_size.htm http://www.ixora.com.au/tips/block_size.htm

Steve Adams however fails to address the (admittedly rare) times in Oracle when there lock contention on a block (rather than a row) e.g. cache buffers chains latch contention on the root block of a heavily modified index, which for some applications reduces the appeal of large blocksizes.

-- 
Andrew Mobbs - http://www.chiark.greenend.org.uk/~andrewm/