I worked on a system that was being developed on Raid-5. We didn't experience any I/O performance issues until I converted the singleton inserts/updates to array inserts/updates. Then we bottlenecked on the redo logs. We moved those off to a Raid 0+1 and the I/O bottleneck went away. At least until the project was cancelled.
This was an EMC cabinet with like 5G of cache. Kevin -----Original Message----- Sent: Friday, November 01, 2002 12:00 PM To: Multiple recipients of list ORACLE-L I have never been given a choice to use anything other than RAID 5. The storage management group dictates what we get and the Server admin group and DBA's have to live with it. (Large IT shop everything in its own silo). Though it has not been the end of the world being on RAID 5, but then I was using EMC SAN and we have since switched to Hitachi SAN. The disk i/o performance has cetainly been fine with the RAID 5. In fact it improved when we eliminated our SCSI controllers and went to Fibre channels. If I had an application that had high transaction volumes or required the steady diet of tuning to get the last bit of performance out of the system to get an acceptable performance. Then I might be more concerned. I guess basically I am saying that the choice between RAID 5 vs RAID 0+1 is also going to depend on the application processing requirements. The trade off in performance might be more than compensated for by the cost. Everyone wants a fast car, but few can afford it and fewer actually need it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M 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).
