Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: What is a good blocksize to use.

Re: What is a good blocksize to use.

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Tue, 24 Sep 2002 22:21:23 +0100
Message-ID: <3d90dc3c_2@mk-nntp-1.news.uk.worldonline.com>


"Ben Brugman" <benbrugman_at_onbekend.nl> wrote in message news:3d90781f.26180500_at_news.nl.uu.net...
> 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 ?
>
> What are the effects of going smaller in blocksize ?
> What are the effects of going larger in blocksize ?
>
> ben brugman
> Ben Brugman

Ben,

Insufficient input. Go for 8K, or provide more detail.

Regards,
Paul Received on Tue Sep 24 2002 - 16:21:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US