Re: STRIPING AT Oracle Level

Without specific requirements, I would consider ASM as *one* of the most viable options for *JBOD*. Even mirroring features of ASM can be used assuming you have more than just couple disks. I'd say there is practically no overhead from ASM except write mirroring hit.

It also quite cheap (read free) and you are not locked into any hardware. You can simply move your disks to another machine and can mount ASM disks there with no problems.

You would want to test disk failures on your platform and how you recover from that and make sure procedures are clean. It wouldn't guarantee that the real failure will go same way but at least you would have a plan.

On 10/27/07, DBA Deepak <oracle.tutorials_at_gmail.com> 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

-- 
Alex Gorbachev, Oracle DBA Brewer, The Pythian Group
http://www.pythian.com/blogs/author/alex http://www.oracloid.com
BAAG party - www.BattleAgainstAnyGuess.com
--
http://www.freelists.org/webpage/oracle-l