Re: Best setting of db_block_size on NT

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:05:03 CDT