Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: STRIPING AT Oracle Level

Re: STRIPING AT Oracle Level

From: DBA Deepak <oracle.tutorials_at_gmail.com>
Date: Mon, 29 Oct 2007 22:33:46 +0530
Message-ID: <75aa80160710291003j6fa4b056p3f3acb4c9196285a@mail.gmail.com>


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
Received on Mon Oct 29 2007 - 12:03:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US