Not to mention the several-hour fsck on large UFS MPs on reboot after a crash. Been there, done that...
Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] 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. Thanks, Matt -- Matthew Zito -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
