Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle IO tuning tips/practices on Windows

Re: Oracle IO tuning tips/practices on Windows

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: 1 Feb 2006 22:39:25 -0800
Message-ID: <1138862365.402587.258770@f14g2000cwb.googlegroups.com>


bdbafh_at_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. Received on Thu Feb 02 2006 - 00:39:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US