Re: recommended raid level for 8i?

In a development environment, you can probably get away with a mix. Unless you are sure about your I/O demands putting write intensive data on RAID 5 can cause serious performance problems. However, if you seperate out rollback, redo and temp to 0+1, most of the rest of the database can probably do fine in RAID 5.

One thing, make sure your stripe depth is set to be an integer multiple (usually 1 or 2) of db_file_multiblock_read_count * db_block_size. Otherwise you can have a negative impact on concurrency (it is better to let two processes access 2 spindles than to speed up one process by letting it access 2 spindles concurrently).

Mike

On Mon, 11 Jun 2001 22:16:54 +0200, "John Theunis" <john.theunis_at_advalvas.be> wrote:

>hi,
>
>If you are the DBA, I would say: never settle for raid 5 because it is
>'cheaper' and the 'overhead is minimal'
>Sure managers want fast, good & cheap things, preferebly all at the same,
>but in the end, when performance goes down because raid5 just can't handle
>'those one or two exceptional quick & dirty queries' which genereate huge
>rollback, redologs, data & index segment I/O, they will again come knocking
>on the dba's door...
>
>What 's the cost of a 10k scsi drive these day anyway?
>
>kind regards
>john
>
>
><NOtakmel_at_stratos.netSPAM> wrote in message
>news:3b25086f.20614548_at_news.fnsi.net...
>> Need to procure an wintel box (W2k srv) to put Oracle8i standard.
>> Which h/w raid level is recommended: raid 5 or raid 0+1?
>>
>> TIA,
>> Robert
>
>
  Received on Mon Jun 11 2001 - 21:27:00 CDT