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: <yong321_at_yahoo.com>
Date: 2 Feb 2006 07:21:42 -0800
Message-ID: <1138893702.545472.117220@f14g2000cwb.googlegroups.com>


Noons wrote:

>

> Check that these partition(s) was/were created and formatted with a
> sector size that matches the database block size (8K?).

I think you meant allocation unit or cluster size, not sector size. It's the number you provide for format /a: switch. A sector size can only be changed by the hard drive maker. I'm not sure if bigger sector size hard drives are commercially available.

Yong Huang Received on Thu Feb 02 2006 - 09:21:42 CST

Original text of this message

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