Xref: alice comp.databases.oracle.server:58246 Path: alice!news-feed.fnsi.net!netnews.com!dca1-hub1.news.digex.net!dca1-feed1.news.digex.net!intermedia!news.ipass.net!not-for-mail From: "David Sisk" Newsgroups: comp.databases.oracle.server References: <932478198.5480.0.nnrp-06.c2d9cf02@news.demon.co.uk> Subject: Re: Best setting of db_block_size on NT Lines: 25 X-Newsreader: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 Message-ID: Date: Tue, 20 Jul 1999 22:29:50 -0400 X-Complaints-To: abuse@ipass.net X-Trace: news.ipass.net 932523613 209.170.134.13 (Tue, 20 Jul 1999 22:20:13 EDT) NNTP-Posting-Date: Tue, 20 Jul 1999 22:20:13 EDT Organization: iPass.Net 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@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 > >