Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can the Oracle db_block_size be changed on an instance?

Re: Can the Oracle db_block_size be changed on an instance?

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Fri, 19 Apr 2002 21:08:53 +1000
Message-ID: <a9otvg$jh0$1@lust.ihug.co.nz>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US