Currently, one of our customers has kept all the datafiles and redo log files on a set of disks with RAID 5? There are lot of I/O corresponding to certain datafiles. So, what can we do if severe I/O occurs at database level?
Had it not been RAID, I would have kept the datafiles of tablespaces with high I/O on a different disk.
Can I keep the datafiles of tablespaces with high I/O on a separate RAID 5 array? In this way, some of the datafiles would reside on one array and other datafiles would reside on other array. Would it help?
Please correct me if my understanding is incorrect.
Attached is the AWR report. It has high db file seuqential read. The database has run for 4 and a half hours and number of seconds of db file sequential reads is around 22000 i.e. 6 hours (approx).