Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle IO tuning tips/practices on Windows
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