Re: Storage basics for Oracle DBA

bdbafh_at_gmail.com wrote:

> His book covers much more than just storage ... "Scaling Oracle 8i" by
> James Morle is downloadable from his website:
>
> http://www.scale-abilities.com/thebook.shtml
>
> Page 85 starts coverage of Storage Subsystems.
> Parts are a little bit out of date, such as SCSI protocols (160 and 320
> MB/sec have come along since this was published). NAS filers weren't
> used back then and hard drive rotational speeds have increased to
> 15,000 RPM.
>
> This is one of those books for which I picked up a second copy for home
> use (like Practical Oracle Databases and Effective Oracle by Design).
>
> He also wrote a paper named "Sane SAN" that is more recent.
>
> Gaja Vatnahayanahaya's Oracle Performance Tuning 101 book was released
> as an eBook by Veritas.
> (Oracle Press, Gaja Krishna Vaidyanatha, Kirtikumar Deshpande)
> http://www.veritas.com/Vrt/offer?_requestid=78308&a_id=3338&
>
> http://www.storagemagazine.com has some content that you may find
> helpful (registration required for some articles).
>
> hth.
> -bdbafh

On the subject of storage it is time to call something a myth: That you should not use RAID 5 for applications that perform heavy writes.

That statement may well be true for most storage arrays but I am now aware of one on which RAID 5 writes faster than RAID 1+0.

So the answer, from now on, is "it depends on your hardware vendor."

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)