 | | | -none- | -none- 2007-09-05 - By Allan Nelson
Back
This seems like a fairly bad setup whichever of these two alternatives you
take. It is possible that the raid0 stripe would give you good performance
as there is the possibility of getting multiple spindles into a read request
and thus getting your data faster. It assumes that the hot blocks are
striped evenly across the disks. The raid0 stripe is more likely to fail
than a single disk and it will lose the whole database. A three file layout
with one per disk would give you the potential to only need to recover one
file and with careful distribution of the hot blocks would give nearly the
same performance.
On the whole however, if you have a heavy I/O load then the 3 disks is the
problem regardless of how you configure them.
Allan
On 9/5/07, DBA Deepak <oracle.tutorials@(protected)> wrote:
>
> Hi Oracle Experts,
>
> If one has three disks. And the goal is to reduce i/o contention of the
> tablespace.
> Which of the following would be a better solution and why?
>
> 1>RAID 0 of three disks and a single file striped across
> 2>Three files for the tablespace spread across all the three disks
>
>
> --
> Regards,
>
> Deepak
> Oracle DBA
>
This seems like a fairly bad setup whichever of these two alternatives you take
. It is possible that the raid0 stripe would give you good performance as
there is the possibility of getting multiple spindles into a read request and
thus getting your data faster. It assumes that the hot blocks are striped
evenly across the disks. The raid0 stripe is more likely to fail than a
single disk and it will lose the whole database. A three file layout with
one per disk would give you the potential to only need to recover one file and
with careful distribution of the hot blocks would give nearly the same
performance.
<br><br>On the whole however, if you have a heavy I/O load then the 3 disks is
the problem regardless of how you configure them.<br><br>Allan<br><br><div>
<span class="gmail_quote">On 9/5/07, <b class="gmail_sendername">DBA Deepak
</b> <<a href="mailto:oracle.tutorials@(protected)">oracle.tutorials@(protected)
</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px
solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>Hi Oracle Experts,</div>
<div> </div>
<div>If one has three disks. And the goal is to reduce i/o contention of
the tablespace.</div>
<div>Which of the following would be a better solution and why?</div>
<div> </div>
<div>1>RAID 0 of three disks and a single file striped across</div>
<div>2>Three files for the tablespace spread across all the three
disks</div><span class="sg">
<div><br clear="all"><br>-- <br>Regards,<br><br>Deepak<br>Oracle DBA </div>
</span></blockquote></div><br>
|
|
|