Re: Configuring RAID for best Oracle performance

In article <pinnacle-0501950848470001_at_hou01.onramp.net> pinnacle_at_onramp.net (Pat Kelly) writes:
>How should I configure a new RAID subsystem to balance the opposing
>requirements of good Oracle performance and good data availablity? I
>understand that there are trade-offs but I'd like to learn from others'
>experiences and even theories so I don't have to reinvent the wheel. It
>would be nice to have the system keep running without physical
>intervention should a disk drive fail but the users (of course!) demand
>the best performance.
>

[snip]

Have you seen "ORACLE DBA Handbook" by Kevin Loney from ORACLE Press? I highly recommend it for all sorts of questions regarding DBA issues. Also, they just published a book called "Performance Tuning for ORACLE", or something like that. I plan to get that in addition to the handbook.

One of the things that cracked me up in the handbook was a discussion of ideal hardware configuration. They started off with a 21 (!) disk solution, but then they whittled it down to seven. Of course, I only have two to work with. I guess you can solve anything with money. Regardless, it does present the issues involved in a clear manner. It's not bad as casual reading, either.

Matt Lih (lih_at_venice.sedd.trw.com) Received on Thu Jan 05 1995 - 21:25:52 CET