Re: datafiles vs. logical volumes for disk striping

IMHO :-) - Unless I need to control extent placement by datafile, I prefer letting the LVM do all my striping. It's faster, makes recovery easier and doesn't stop me from placing tablespaces where I want.

Plus, it shifts work load to the SA :-) .

Regards,
jh

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?
>

Jared Hecker              | HWA Inc. -
jared_at_hwai.com            |  Oracle Architecure and Administration
76276.740_at_compuserve.com  |  serving the NJ/NYC region