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@xxxxxxxxx> 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@xxxxxxxxx> 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@xxxxxxxxx> > > To: "amar.padhi@xxxxxxxxx" <amar.padhi@xxxxxxxxx> > > 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@xxxxxxxxx> 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@xxxxxxxxx > > > > To: "oracle-l" <oracle-l@xxxxxxxxxxxxx> > > > 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 > > > > > > -- > > > //www.freelists.org/webpage/oracle-l > > > > > > > > > > > > > > > -- > > Regards, > > > > Deepak > > Oracle DBA > > > > -- > > //www.freelists.org/webpage/oracle-l > > > > > > > -- Regards, Deepak Oracle DBA