Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: STRIPING AT Oracle Level
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-lReceived on Mon Oct 29 2007 - 10:41:39 CDT