A bit of background on why this config used - This database collects network sniffing info, which is not considered mission cricital. Hence they went for a closed box RAID 0 configuration. The customer is reponsible for any backups. All the datafiles on bunched up on 3 disk RAID 0. OS/redo/control/temp/undo and bunched together on 1 - non RAID disk. Here are the wait event for 7 million inserts:

Here are the top 5 wait events based on the statspack report:
Event Waits Time (s) Ela Time
------------------------------------- ------------ ----------- --
log file sync 44,342 21,530 52.61
log file parallel write 75,561 10,885 26.60
db file sequential read 4,609,459 2,982 7.29
db file parallel write 15,473 2,847 6.96
control file parallel write 7,220 802 1.96
----------------------------------------------------------------------

Can someone point any info on how a single SCSI raid controller works on a disk array? Are the disk reads/writes asychronous and parallel with just one controller? Or are they queued? Does it help if we have 3 controllers for 3 disk RAID?

The closed box can not accomodate more disks unless the whole box is changed.