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?

This Content Component encountered an error
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 first published in May 2006

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close