Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!f14g2000cwb.googlegroups.com!not-for-mail
From: "Noons" <wizofoz2k@yahoo.com.au>
Newsgroups: comp.databases.oracle.server
Subject: Re: Oracle IO tuning tips/practices on Windows
Date: 1 Feb 2006 22:39:25 -0800
Organization: http://groups.google.com
Lines: 12
Message-ID: <1138862365.402587.258770@f14g2000cwb.googlegroups.com>
References: <qjf2u1totvqj4q2l6v6tv9bcjojh9bvu0g@4ax.com>
   <1138842750.019797.128420@g44g2000cwa.googlegroups.com>
NNTP-Posting-Host: 210.0.85.163
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1138862370 9836 127.0.0.1 (2 Feb 2006 06:39:30 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 2 Feb 2006 06:39:30 +0000 (UTC)
In-Reply-To: <1138842750.019797.128420@g44g2000cwa.googlegroups.com>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8) Gecko/20051111 Firefox/1.5,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: f14g2000cwb.googlegroups.com; posting-host=210.0.85.163;
   posting-account=oL3mOwwAAADEs_7uf002tZwWvleermlz
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:260542

bdbafh@gmail.com wrote:

> What filesystem block size did you choose for the filesystem(s) that
> support your datafiles? I hope that it matches your db_block_size.
>

He's only got one file system: NTFS.  Don't forget,  it's Windoze.
Block size is immaterial, but sector size isn't: if it doesn't approach
the
db block size, then he's immediately got an IO performance problem
in his hands.  Ideally, it should be the same as the db block size.