Q

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?

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.

This was last published in May 2006

Dig Deeper on Oracle database design and architecture

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close