Re: STRIPING AT Oracle Level

Yes to both.

Finn

On 10/29/07, DBA Deepak <oracle.tutorials_at_gmail.com> wrote:
>
> Hi Finn,
>
> >> although it will not necessarily be consistent,
>
> I understand that it may not be consistent (as the stripe size will be in
> extents). Please correct me if I am wrong.
>
> >> but that depends on tablespace setup.
>
> Here do you want to point out that only LMT+Uniform extent size is going
> to help?
>
> Regards,
>
> Deepak
>
>
> On 10/29/07, Finn Jorgensen <finn.oracledba_at_gmail.com> wrote:
> >
> > 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
> > >
> > >
> > >
> >
>
>
> --
> Regards,
>
> Deepak
> Oracle DBA

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