Re: datafiles vs. logical volumes for disk striping

I have actually had the opportunity to look side by side at the performance of hand striping vs LVM. The truth is that the system was designed to stripe. It does it better than me. I have heard, (but not tried) that raided systems actually work better when saturated....

-sheilah scheurich
DBA
On 21 Apr 1997 12:49:43 GMT, mleung_at_cyberus.ca ( ) wrote:

>For some time now I've wondered about whether disk striping could be better
>achieved with datafiles only instead of the traditional combination of both
>datafiles and logical volumes. Is it true that distribution across multiple
>disks can be more accurratly done with datafiles only? Of course I realize
>that to do so would probably require alot more work on the part of the DBA
>(he/she would have to size each object then perhaps define individual
>tablespaces sized in such a way so that the table is evenly distributed
>across all datafiles, perhaps the Oracle max datafile restriction might
>come into play) thus making it impractical.
>
>Also is it always a good policy to stripe all objects (except perhaps the
>smallest tables which can be read in with one disk access) across all disks?
>Under what circumstances would this not be a good policy?
>
Received on Thu May 01 1997 - 00:00:00 CDT