Re: Best setting of db_block_size on NT

In general, I'd go with an 8K database block size on NT. The O/S block size is 2K, but this is too small for most applications, whether OLTP or DSS.

Good luck,

--
David C. Sisk
The Unofficial ORACLE on NT site
http://www.ipass.net/~davesisk/oont.htm

Nick Rumble wrote in message
<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 - 21:29:50 CDT