Ask the Expert

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?

    Requires Free Membership to View

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

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: