Re: STRIPING AT Oracle Level

  • From: "Finn Jorgensen" <finn.oracledba@xxxxxxxxx>
  • To: oracle.tutorials@xxxxxxxxx
  • Date: Sat, 27 Oct 2007 18:25:01 -0500

How about using ASM and let Oracle do the striping that way? If you're in
10g you should be able to do that on most all platforms.

Finn


On 10/27/07, DBA Deepak <oracle.tutorials@xxxxxxxxx> wrote:
>
> Hi Experts,
>
> Due to cost implications of RAID controllers we have thought of
> implementing striping at Oracle level using multiple data files per
> tablespace and spreading them across various disks. Our goal is to
> distribute IO uniformly across disks. Would like to have your expert
> comments on the following...
>
> > Is the above a better approach than balacing the IO by placing various
> objects in different tablespaces based on the IO on them i.e., by
> monitoring the IO on various objects and placing them in appropriate
> tablespaces depending on the IO that happens on them?
>
> What are the pros-cons in our approach?
>
> --
> Regards,
>
> Deepak
> Oracle DBA
>

Other related posts: