Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Can the Oracle db_block_size be changed on an instance?
As the previous messages indicate, the answer is no. However, if you are having performance problems due to a small block size - then try playing with the init.ora parameter DB_FILE_MULTIBLOCK_READ_COUNT. I.e. if your block size is 2k (2048 bytes) then try setting this parameter to 8 or 16. It increases read performance by reading more data per disk I/O.
Regards,
Mark Bateman
Oracle expertise around the clock
www.teamsolve.co.uk
<44apples44_at_44apples44.freeserve.co.uk> wrote in message
news:a9hbst$3rq$1_at_news8.svr.pol.co.uk...
> Can the Oracle db_block_size be changed on an oracle instance: HPUX 11.00
> Oracle 8.0.6.
>
> Cheers
> Jon
>
>
Received on Fri Apr 19 2002 - 04:15:20 CDT