Browse oracle-l: This Month's Archive • Main Archive Page • Related posts • Previous by Date • Next by Date

RE: RAID 0 Vs Multiple files per tablespace spread across

From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
To: <oracle.tutorials@xxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
Date: Wed, 5 Sep 2007 11:00:44 -0700

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.

References:

RAID 0 Vs Multiple files per tablespace spread across
From: DBA Deepak

RE: RAID 0 Vs Multiple files per tablespace spread across

Other related posts: