Especially if all you have is three mirrors. With that few places to put
things, you won't be able to separate everything (tables, indexes, archives,
redo logs, sort areas, etc.) on its own mirror. Using a single striped
mirror is the only way you can guarantee any kind of balanced I/O.
RAID 0+1 and RAID 1+0 provide similar performance but RAID 1+0 has the
advantage of offering more redundancy/availability. If you take your sys
admin's advice and go with 2 x 3 disks in a 0+1 config and you lose one
disk then you lose the other two spindles in that stripe as well. That's
systems.
Jared
Gudmundur Bjarni Josepsson [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/02/2003 02:20 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: Raid 0+1 vs. mirrored pairs
RAID 0+1
Separating tables from indexes is one of those mythical things.
I agree. It is not given that separating those two will have much impact
on performance. However, as you point out yourself it is dependent on the
amount of IO. I did say it was nice to be able to separate different
database