Re: RAID-5 and Oracle Performance

From: "Jeff Shervey" jeff.shervey_at_us.landisstaefa.com_spamblock> >> My UNIX admin wants to throw our Oracle Manufacturing database on one single giant 54GB RAID-5 array. I don't really agree. Because Oracle data and indexes won't really be separated from disk drive heads. <<

I would not worry about separating the tables and indexes as much as I would worry more about having to recover the entire database if you lose just one disk. Raid 5 only protects againt the loss of one disk in a raid set. Personally, I think you would be a lot better off having 16 4G drives instead of 7 9G drives and four raid sets depending on how large the individual tables and indexes that you are working with are. You did not say if this is a DSS or OLTP type application so that and the number of concurrent users will really determine if you can get away with putting so much data on one drive.

Good Luck.  

Mark Powell -- Oracle 7 Certified DBA
- The only advice that counts is the advice that you follow so follow your own advice - Received on Thu Jan 29 1998 - 00:00:00 CST