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.


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: