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?
On full tablescans only. And only up to the actual physical capabilities of
your hardware.
Regards
HJR
"Mark Bateman" <nowhere_at_nowhere.com> wrote in message
news:ueRv8.336$A43.155504_at_news11-gui.server.ntli.net...
>
> 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 - 06:08:53 CDT
![]() |
![]() |