 | | | -none- | -none- 2007-09-05 - By Allen, Brandon
Back
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.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16525" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=501395317-05092007><FONT face=Arial
color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=501395317-05092007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=501395317-05092007><FONT face=Arial
color=#0000ff size=2>Regards,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=501395317-05092007><FONT face=Arial
color=#0000ff size=2>Brandon</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left> </DIV>
<DIV><BR clear=all> </DIV></BODY><!--[object_id=#oneneck.com#]--><FONT
face=Tahoma size=2><FONT color=#0000ff>
<P>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.</P><
/FONT></FONT></HTML>
|
|
|