Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Tnuning---Block Size, How much difference?
Well, if you did not alter things like db_block_buffers, you buffers are half
as well, so that does make a change in performance! Why did you half it anyway? Usually bigger performs better, tho you cannot take this to unlimited.
Sean Zhang 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
--
Met vriendelijke groet,
kind regards,
Frank van Bortel
Technical consultant Oracle
V&L Informatica BV
Work Home Postbus 545 Hunzestraat 4 7500 AM Enschede 7555 WB Hengelo (31)53.434.1500 (31)74.242.5046Received on Tue Apr 20 1999 - 09:48:31 CDT