Re: STRIPING AT Oracle Level

Deepak,

One issue with the "striping" mechanism you're suggesting is if you ever add another disk to your setup, rebalancing the load becomes near impossible.

You're approach is not great, but if it's all you've got to work with there are no actual issues with it and it will provide a poor-mans basic level striping, although it will not necessarily be consistent, but that depends on tablespace setup.

Finn

On 10/29/07, Amar Kumar Padhi <amar.padhi_at_gmail.com> wrote:
>
> Hi Deepak,
> Though traditional, datafile wise striping is still the best kind of
> defence on JBOD. Others on the list can add.
>
> If you are using internal set of disks, you can create a s/w RAID base
> from OS. I have done this on Linux OS (works great, but doesn't support hot
> swapping). Besides, Most basic DAS, SAN and NAS (almost all) come with RAID
> controllers, it's part of the package.
>
> thanks!
> amar kumar padhi
> www.amar-padhi.com
> pushed from PDA
>
>
> -----Original Message-----
> From: "DBA Deepak" <oracle.tutorials_at_gmail.com>
> To: "amar.padhi_at_gmail.com" <amar.padhi_at_gmail.com>
> Sent: 28-10-07 18:56
> Subject: Re: STRIPING AT Oracle Level
>
> Hi Amar,
>
> Thanks for your nice explanation. But would like to have your opinion
> on the following...
>
> Let's assume that hardware/software RAID is not feasible for a shop.
> Then will striping at Oracle level (by having multiple data files
> across disks) be a good solution? Do you see any issues with this
> approach?
>
> Looking forward to your expert advice on this.
>
> Regards,
>
> Deepak
>
> On 10/28/07, Amar Kumar Padhi <amar.padhi_at_gmail.com> wrote:
> > 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
> >
> >
> >
>
>
> --
> Regards,
>
> Deepak
> Oracle DBA
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l