Re: RAID level suggestions

Tolson Smith (tsmith_at_cyberus.ca) wrote:

: I am in the process of setting up our new UNIX enviornment and I have a
: question about RAID levels and what people's suggestions are.
 

: Currently I have a Oracle database (7.1.6.2) on OpenVMS on a RAID drive level
: 0+1 that is approximately 4GB.
 

: Given that some RAID level will be run in our organization I am looking for
: recommendations of what level the actual data should be put on. I recognize
: that the RollBack segments, temporary space and the redo logs are write
: intensive and there for should not most likely be located on the same drive as
: the data. We currently are doing approximately 12 to 15 % write activity and
: the rest is reading.
 

: Please post here or email me, I check the system several times a day.
 

: Tolson Smith
: tsmith_at_cyberus.ca

Assuming that write times are important to you:

 Raid 1/0 or 1 for writes
 Raid 5 for reads

This is at best approximate, because so much depends on the number of devices, disk cache, application characteristics etc. I use RAID 1, 1/0 and 5 extensively, but fromexperience it is important to have a large number of physical drives available - a minimum of three per stripe, five is better.

RGDS Nick

--
+==============================================================================+
+    Nick Price                               Technical Consultant             +
+    Internet: nprice_at_7-Eleven.com.hk         Hong Kong Convenience Stores Ltd.+
+    Tel     : +852 2802 6869                 North Point                      +
+    Fax     : +852 2802 1447                 Hong Kong                        +
+==============================================================================+