| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_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 <LEROBE_at_acxiom.co.uk> 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_at_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_at_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_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=20 -- Author: Jay Hostetter INET: jhostetter_at_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_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 mayReceived on Fri Oct 27 2000 - 08:52:26 CDT
 |
 |