Re: Help with Virgin RAID system

Sun's Volume manager (vxva) will allow you to construct any sort of volume that you wish to create. You can create a straight disk, or you can create any of the following formats of raid.
raid0 (striped), raid1(mirrored), raid5 and also raid10(or raid 0+1, being striped with mirroring).

If you afford to do it, with sun's volume manager and Oracle's new rman backup tool, raw volumes are really easy to manage now. The performace that you get from going raw is of course nice, but the additional control that you get from being able to place each and every datafile (and set the format of raid) really makes it nice.

Rule of thumb: Use raid10 for everything! If you can't do that, then stay away from anything that is necessary for Oracle to run.

control,system_ts,temp_ts,rollback_ts,redo_logs all should be raid10. (I usually add 2 mirrors for the system_ts) the rest can be raid5, but avoid tablespaces that have heavy writes and few reads.

Figure that it will take roughly 2.5 times longer to write to a raid 5 disk as it does to read. That number does improve as the number of drives in the volume go up, but not much.

Darren John Capper <darren.capper_at_preci-spark.co.uk> wrote in message news:37D37FA3.ACA7B5B9_at_preci-spark.co.uk...
> Oracle Guru's,
>
> My company has just purchased a Sun Enterprise server along with a RAID
> array (RAID 5 I think). It's going to be about two months before I get
> my hands on it and I was wondering how RAID will affect my Oracle
> setup. Do I need to be concerned with which disk a particular table is
> on or will RAID stripe it anyway?
>
> Any comments or pointers in the right direction will be greatly
> appreciated.
>
> Regards,
> Darren
>
Received on Wed Sep 08 1999 - 06:34:10 CDT