RE: STRIPING AT Oracle Level

Hi Deepak,
Doing manual striping is not exactly the same as RAID striping. RAID controllers have properties like stripe width and size (chunksize) that allows separation of data in KiB and MiB. So you may have same datafile being written in chunks to different disks. New RAID devices also allow for "hot blocks" identification and reshuffling. This is inline with Oracle's SAME concept.

Alternatively, you can make use of Oracle's ASM that gives you the same option. What I do not know is if this also will cost you extra bucks?

My recommendation is to with hardware RAID rather than a software one.

thanks!
amar kumar padhi
www.amar-padhi.com
pushed from PDA

-----Original Message-----
From: "DBA Deepak" <oracle.tutorials_at_gmail.com> To: "oracle-l" <oracle-l_at_freelists.org>
Sent: 28-10-07 02:04
Subject: STRIPING AT Oracle Level

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