Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: stripe size

RE: stripe size

From: Jesse, Rich <>
Date: Tue, 19 Aug 2003 12:14:25 -0800
Message-ID: <>

Not to mention the several-hour fsck on large UFS MPs on reboot after a crash. Been there, done that...


Rich Jesse                           System/Database Administrator                  Quad/Tech Inc, Sussex, WI USA 

-----Original Message-----

Sent: Tuesday, August 19, 2003 11:59 AM
To: Multiple recipients of list ORACLE-L  

Depends on the storage being used and the number of spindles. I definitely wouldn't go any smaller than 8k, but 8k is probably fine on a JBOD array, especially if you're matching your filesystem block size to your oracle block size to your stripe size. You might want to look at changing it to 16k if you're using high-speed disks and let the disk firmware's read-ahead and large cache give you a bit of a boost. You're probably not talking about a huge jump, though - only if you're really saturating your disks will you notice a difference.  

As I've said in the past, the rules change completely when you're using a "smart" array like a Hitachi lightning or an EMC symmetrix, or even a smaller one like a Clariion or HP EVA. For those, engage your vendor's performance engineers or hire someone like me to come in and tune your storage, or just invest a lot of time in learning how your array works and experiment.  

You should look at using VxFS as well - you can eliminate double-buffering and get asynch kernel i/o, which alone could provide much better throughput. Depending on your Solaris version, as well, you could be creating unnecessary memory pressure by using UFS.  


Matthew Zito

Please see the official ORACLE-L FAQ:

Author: Jesse, Rich

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services

To REMOVE yourself from this mailing list, send an E-Mail message
to: (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Aug 19 2003 - 15:14:25 CDT

Original text of this message