RE: RAID 0 Vs Multiple files per tablespace spread across

I'm not positive on this, but I think RAID 0 would be the best option to minimize contention since the data would be randomly distributed across the 3 disks and therefore less likely that all or most of the data from a single query would all come from a single disk. With the 3 datafiles, I'm pretty sure Oracle will write to all of them in a round-robin fashion, but I'd bet there are certain situations where you could end up with logically related data being physically grouped as well and then you may end up having to read all those blocks from a single disk instead of spreading the load. I feel like I'm missing something though so I'd have to think about this one more, but no time now - curious what others have to say.  

Regards,
Brandon    

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

--
http://www.freelists.org/webpage/oracle-l