Optimal RAID configuration
What is the optimal RAID configuration for an Oracle general-purpose database, since you mentioned that RAID 3 and 5 include write issues? What is the best environment? RAID 1 and RAID 5 or what?
Many top-rated Oracle professionals feel that RAID 1 is preferrable to RAID 5. You can read more about this topic on BAARF. You can see that I am one of the members of BAARF.
Databases tend to be write-intensive. Your temp tablespace, the online redo logs and the control files (at a minimum) experience high write activity. The write penalties associated with RAID 3 and RAID 5 can slow down your database application performance. However, RAID 5 is great for read mostly databases since you can have multiple database spindles performing your read operations. However, RAID 0+1, which does mirroring and striping, will enjoy the benefits for reading that RAID 5 does and not have a write penalty. So I prefer to stick with RAID 1 or RAID 10 (another term for 0+1) for my Oracle databases.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments