Re: Oracle Block Size and Solaris 2.6

From: Robert Miller <robert_at_rjmiller.freeserve.co.uk>
Date: Sun, 6 Dec 1998 14:06:43 -0000
Message-ID: <74e2uf$vee$1@newsreader1.core.theplanet.net>

A couple of things

Check your filesystem block size if its say 8K then setting the DB Block size to something smaller say 4k would cause Oralcle to read 8K no matter how smaller read is required.

Block size depends on the type of data you are reading back if its small rows then a small block size, if its large rows the a bigger blocksize. ie if one row for example is 7K then a block size of 4K = 2 reads where a block size of 8k would be one read,

Paul_at_Matthews.Com wrote in message <749br0$lip$1_at_nnrp1.dejanews.com>...
>Is there a general rule of thumb for the Oracle Block Size on Sun Sparc
2000
>running Solaris 2.6? I would have thought 8- or 16-KB, but the previous
DBA
>said 2-KB would be better with Solaris 2.6. Any recommendations?
>
>Is there an easy way to optimize block size other than by trial and error?
>Thanks,
>
>Paul Matthews
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Sun Dec 06 1998 - 08:06:43 CST