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: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Mon, 29 Oct 2007 15:41:39 +0000
Message-ID: <7765c8970710290841l27b4f804x6d6cd632a327eb73@mail.gmail.com>


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

What cost implications? Hardware raid is dirt cheap on server class hardware - almost certainly cheaper than your Oracle license. In fact if you can find server class hardware that *doesn't *have hardware RAID I'd be amazed. And if you aren't using server class hardware I doubt that IO balancing would be the best area to concentrate your efforts. You need redundancy to protect against failure and your proposed solution does not offer that. ASM does as others have mentioned. Hardware raid also does.

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

Cons:
*When* you lose a disk then you *will* lose some data and have to perform incomplete recovery.

Pros:
It is likely to be a better approach in the constraints that you have set than micro managing contention at the object level.

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 29 2007 - 10:41:39 CDT

Original text of this message

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