Ask the Expert

How RAID affects your DBA workload

How does using RAID affect the workload of a DBA?

    Requires Free Membership to View

It depends on how RAID is configured. If it's RAID 5, for example, your workload is likely to increase, as Oracle performance is often poor with this setup. A properly-configured RAID (ideally RAID 10, or mirrored and striped volumes) storage subsystem, however, should not materially increase a DBA's workload once implemented. Most of the work involved in using RAID lies in the planning, ideally done in conjunction with your system administrator. Note also that Oracle10g provides a great new feature called Automatic Storage Management (ASM), which takes over management of all of the disk devices allocated to your database. In other words, you can now hand Oracle a pool of disks and Oracle will handle the logical volume and datafile management.

This was first published in May 2004

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: