Re: Oracle Block Size and Solaris 2.6

From: howard <howard.lee_at_connection.com.hk>
Date: Mon, 07 Dec 1998 15:18:42 +0800
Message-ID: <366B8152.C856ED38@connection.com.hk>

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