Ask the Expert

The workings of a single enterprise subsystem

I enjoyed your webcast on "Designing your SAN for mission critical OLTP applications." Can you recommend any books or white papers on the same subject besides the November issue of "Storage" magazine?

Also, on an enterprise array subsystem the disk channels provide enough performance I/O to support both DB and log files within same array subsystem due to Fibre controllers/split I/O and redundancy. Do you agree?


    Requires Free Membership to View

The Oracle Web site has a few good white papers I've listed them below:

Guidelines for Using Remote Mirroring Storage Systems for Oracle Database by J. Bill Lee, Oracle November 1999.

Guidelines for Using Snapshot Storage Systems for Oracle Databases by Nabil Osorio and Bill Lee, Oracle Corporation October 2001.

Optimal Storage Configuration Made Easy by Juan Loaiza, Oracle Corporation.

As to your question/statement about a single enterprise subsystem supporting both log and tablespace I/O, yes of course it can work. If you are running a transaction processing system you want to look out for I/O bottlenecks. One way to avoid them is to put log file write-intensive I/O on a dedicated channel with dedicated disks. I would be more concerned about disk contention than I would about channel bottlenecks.

As always there are many variables involved with something as complex as database TP I/O.

Regards,
Marc

Editor's note: Do you agree with this expert's response? If you have more to share, post it in one of our .bphAaR2qhqA^0@/searchstorage>discussion forums.


This was first published in April 2003

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: