RE: RAID

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Fri, 27 Oct 2000 14:28:02 -0400
Message-Id: <10662.120492@fatcity.com>

The spindle theory is the usage of separate drives for rollback segs, temp = segs, data segs, index segs, user segs, tools segs, etc. It tries to = follow the Foundation Architechure persrcibed by Oracle and common sence. HTH
ROR =AA=BF=AA >>> Satar.Naghshineh_at_irvine.mellesgriot.com 10/27/00 03:04PM >>> Cache, regardless of RAID level, is always dangerous. That's why when you look for storage solutions, make sure that the cache is mirrored and that there is a backup power device that allows the cache to sync in the drives before powering off. To take it to the next level, make sure the data path to the drives are redundant as well.

Ron, I don't understand the logic behind your spindle theory.=20

by the way, RAID also works well for killing insects!

Regards,
Satar

> -----Original Message-----
> From: Ron Rogers [SMTP:RROGERS_at_galottery.org]=20
> Sent: Friday, October 27, 2000 4:01 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: RAID

>=20

> 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.
Received on Fri Oct 27 2000 - 13:28:02 CDT