Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: STRIPING AT Oracle Level

Re: STRIPING AT Oracle Level

From: Finn Jorgensen <finn.oracledba_at_gmail.com>
Date: Sat, 27 Oct 2007 18:25:01 -0500
Message-ID: <74f79c6b0710271625lbc471f0kfe51ec082d18ff3a@mail.gmail.com>


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_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
>

--
http://www.freelists.org/webpage/oracle-l
Received on Sat Oct 27 2007 - 18:25:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US