Re: Oracle Tnuning---Block Size, How much difference?

From: Alan Lee <alanlee88_at_my-dejanews.com>
Date: Tue, 20 Apr 1999 20:02:57 GMT
Message-ID: <7fimhf$bdo$1@nnrp1.dejanews.com>

Block size really depends on your OS I/O block size. Usually, the bigger the block size, the better the performance. Some Oracle whitepaper quoted about 6%-8% improvement when you double the size. However, I will stick with the OS limitation. In UX 11, we used 16k and usually NT, we used 4k to 8k.

In article <q3KS2.884$jz6.3138781_at_firenze.visi.net>, "Sean Zhang" <sean_at_cnfei.com> wrote:
> Hello, Everybody,
>
> Recently I upgraded our system from Oracle 8 ->Oracle 8i,
> ( in Sun E3000 with Solaris 2.6).
> During the upgrade, I used Export utilities to build a whole new
> database, and the block size was also changed from 4K-> 2K.
> Now I feel the new system is a bit slower than the old system. I read
> some technical books , which say bigger block size could dramatically
> increase the performace, but Oracle documentations stress the
> default block size (2 K) is optimal for our system. I don't know which is
> true
> OR whether the change of block size is the problem making the new
> system slower.
>
> Any suggestions and advices are greatly appreciated.
>
> Sean Zhang
> mailto:sean_at_cnfei.com
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Apr 20 1999 - 15:02:57 CDT