Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Block Size and Solaris 2.6
Paul
normally db block size is used together with db_file_multiblock_read_count. the system should be set so that
os block size = db block size * db_file_multiblock_read_count
in this way, no read buffer will be wasted. the default for solaris is 64K block. if you set the db block size to be 8K, then you should set multiblock read count to 8, and so on.
hope this helps
howard
Paul_at_Matthews.Com wrote:
> 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 Mon Dec 07 1998 - 01:18:42 CST