RAID Gurus - Help!! Urgent!!
I have to tune an 1TB oracle 9i database on Linux that has 1 - 400GB hard disk for OS, system, temp, redo, undo and controlfiles and 3 - 400GB RAID 0 with one SCSI controller for all the other datafiles (tables, indexes etc.,).
I need some info on how the raid controller works when reading and writing to 3 disks in a RAID 0 configuration and how to best to distribute various oracle files in this configuration. For example, if I distribute control/undo/redo/temp between 1 Non-RAID OS disk and 3-RAID 0 disks, does that help or create more contention when writing data to datafiles?