Message-Id: <10662.120437@fatcity.com> From: "Ron Rogers" Date: Fri, 27 Oct 2000 09:52:26 -0400 Subject: Re: RAID The recommendation when using RAID5 is to have disk cache turned off. If = for some unforseen reason the system was to crash when your changes were = in the cache, they would be written as far as Oracle was concerned but = they would be lost in the cache in real life and may not be written at = all. With RAID5 you do not get the versatility of many spindles to place the = data on. It is transformed into one spindle and there will be disk = contention to deal with or live with. If your application can stand = waiting while the tables are updated then RAID5 will work. RAID5 performes = best in a query based application. ROR =AA=BF=AA >>> jhostetter@decommunications.com 10/27/00 09:50AM >>> 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 10/27/00 08:30AM >>> All, =20 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. =20 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/ =20 Regards =20 Lee =20 Lee Robertson=20 Acxiom=20 Tel: 0191 525 7344=20 Fax: 0191 525 7007=20 Email: lerobe@acxiom.co.uk=20 =20 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=20 of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. =20 If you have received this communication in error, please=20 re-send this communication to the sender and delete the=20 original message or any copy of it from your computer system. --=20 Please see the official ORACLE-L FAQ: http://www.orafaq.com=20 --=20 Author: lerobe - Lee Robertson INET: LEROBE@acxiom.co.uk=20 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@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=20 -- Author: Jay Hostetter INET: jhostetter@decommunications.com=20 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@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