Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: [Q]: Raid 0 or Raid 5 for DATA tablespaces : Which is best ?
It is a typically performance vs reliability issue. RAID 0 gives you a better performance whereas RAID 5 gives you a more reliable system. However, RAID 5 can only prevent a disk failure to bring down your system. If you have a mission critical system or a 24*7 system, you may consider use RAID 1 (mirroring). RAID 1 gives you better performance than RAID 5 and more reliable system than RAID 0 and RAID 5. The tradeoff is the disk space!
Kevin Leung
Oracle Financials and Manufacturing DBA
In Article<33EF2888.72B7_at_ldg.bruyeres.cea.fr>,
> From: Jerome Grandjanny <grandjanny_at_ldg.bruyeres.cea.fr>
> Newsgroups: comp.databases.oracle.server
> Subject: [Q]: Raid 0 or Raid 5 for DATA tablespaces : Which is best ?
> Date: Mon, 11 Aug 1997 16:58:16 +0200
>
> Hello all Oracle gurus,
>
> May be this question has been already discussed.
>
> I'am in charge of designing a disk layout for a new database.
>
> I need to decide wether I use RAID 0 (stripping) or RAID 5 for
> the tablespaces containing the data and the indexes.
>
> The database must run 24/24-7/7.
>
> In some books about Oracle, I read that using RAID 5 is not always a
> good choice for data (possible performance problems during write
> operations).
>
> In the other hand, in case of a disk crash, a hot plugging RAID 5
> system can offer a non-stop recovery mechanism.
>
> Please, let me know your opinion, your experience, ...
> Any advice welcome.
> Thanks.
> Sincerely,
> Jerome.
Received on Thu Aug 14 1997 - 00:00:00 CDT