Quote:
Originally posted by blguy
I've basically got the following options (if redo speed is at fault)
1/ I have 6 JBOD drives on the system - I can create 3 pairs of redo drives - each "pair" would be hold one redo set. After a log switch, LGWR would move to the next drive and archiver would use the previous drive. No contention there. But is it fast enough?
2/ I stripe 3 drives and mirror them. Will this be faster that dedicated drives?
3/ I reclaim one of the R5 arrays as redo. (not nice)
4/ I spend many $$$ on solid state REDO drives. BUT NOT before I PROVE redo speed is at the root cause.
BTW - Our ARCH space is a 9 x 72GB RAID5 fibre channel array. We will soon be using a remote STANDBY database - so archives will be shipped over the WAN too.
Your best option would be probably use dedicated drives (but not part of JBOD!) or use JBOD drives in different controllers. You dont need to stripe them, redo logs are written sequentially.