Re: Best setting of db_block_size on NT

Thanks Kevin - I had heard this was true on Unix platforms but I didn't know if there was some overriding factor on NT.

Thanks again

Nick

Kevin A Lewis <KevinALewis_at_Hotmail.com> wrote in message news:490l3.11653$F72.2173_at_newreader.ukcore.bt.net...
> The correct size will depend on the block size used by the OS or disk
system
> which should be used a minimum. Then the actual value will depend on the
> type of application OLTP, DSS etc. and the size of typical table rows.
>
> Needs a fair bit of research to establish the suitable figure - the norm
> these days is to avoid 2k totally and to prefer the large size options.
>
> Regards
>
> --
> Kevin A Lewis (BOCM PAULS LTD - Animal Feed Manufacturer - Ipswich
England)
> <KevinALewis_at_HotMail.com>
>
> The views expressed herein by the author of this document
> are not necessarily those of BOCM PAULS Ltd.
> Nick Rumble <rumbln_at_tetraworld.com> wrote in message
> news:932478198.5480.0.nnrp-06.c2d9cf02_at_news.demon.co.uk...
> > Using a default installation, Oracle 7.3 on NT uses a db_block_size of
> 2k.
> >
> > Is this the best setting or are there "external" factors (such as disk
> NTFS
> > cluster size) that would mean this value should be increased ?
> >
> > Regards
> >
> > Nick Rumble
> >
> >
>
>
Received on Tue Jul 20 1999 - 10:09:46 CDT