Re: STRIPING AT Oracle Level

  • From: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
  • To: oracle.tutorials@xxxxxxxxx
  • Date: Mon, 29 Oct 2007 15:41:39 +0000

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

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

Other related posts: