Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Storage basics for Oracle DBA

Re: Storage basics for Oracle DBA

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Mon, 28 Mar 2005 06:53:32 -0800
Message-ID: <1112021401.13385@yasure>


Shabble wrote:

> "DA Morgan" <damorgan_at_x.washington.edu> wrote in message
> news:1111990411.361572_at_yasure...
> 

>>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)
>>
> 
> 
> I concur, and I'm glad (and kinda relieved) to hear *you* say it. Our System
> Architects demonstrated this on one of our large systems.
> We have to keep an eye on technology advances.
> 
> Shabble.

Thanks. Please send me, off-line if you choose, information on your storage system. I am trying to compile a list.

For those interested ... the system I tested is Apple's new XServe RAID. It has two XOR engines, rather than the usual one, so that even pulling a drive and forcing a rebuild causes almost no performance degredation.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Mon Mar 28 2005 - 08:53:32 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US