Re: RAID

We had an SA run multiple tests to find out whether Raid 5 would work for us. His test proved conclusively that it would work, so Raid 5 was instailled (AIX 4.3 on an IBM SP2). Then the database grew. And grew. And grew. And ... We started experiencing what the DBA's had predicted - slow writes. The SA's came back and said that we should get off of Raid 5 ASAP.

YMMV. Terry

Jay Hostetter wrote:

> Lee,
>
> I think the consensus is to use Raid 0+1. Our sysadmin claims that our disk cache is so large, that it doesn't really matter that we are using Raid 5 (we are on Tru64 4.0d). I really don't have the hardware expertise or the time to prove otherwise. I wouldn't mind hearing some comments on that statement from other folks on the list as they reply to your question. I am able to flood the cache during sqlloader runs, but other that that, he seems to be correct.
>
> Jay Hostetter
> Oracle DBA
> D. & E. Communications
> Ephrata, PA USA
>
> >>> lerobe - Lee Robertson <LEROBE_at_acxiom.co.uk> 10/27/00 08:30AM >>>
> All,
>
> I have seen various threads on the subject of Oracle and Raid but don't have
> any messages stored on the subject so forgive me for the repetition factor.
>
> Can someone provide a list of do's/don'ts, advantages/disadvantages of using
> various raid levels with Oracle (in this case 8) on a TRU64 4.0 platform.
> Database will be approx. 4Tb in size/
>
> Regards
>
> Lee
>
>
> Lee Robertson
> Acxiom
> Tel: 0191 525 7344
> Fax: 0191 525 7007
> Email: lerobe_at_acxiom.co.uk
>
>
>
> The information contained in this communication is
> confidential, is intended only for the use of the recipient
> named above, and may be legally privileged. If the reader
> of this message is not the intended recipient, you are
> hereby notified that any dissemination, distribution or
> copying of this communication is strictly prohibited.
> If you have received this communication in error, please
> re-send this communication to the sender and delete the
> original message or any copy of it from your computer
> system.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: lerobe - Lee Robertson
> INET: LEROBE_at_acxiom.co.uk
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jay Hostetter
> INET: jhostetter_at_decommunications.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Fri Oct 27 2000 - 09:25:35 CDT