Re: Distribution of datafiles over disks vs. striped volume

David-Michael Lincke wrote:
>
> We are planning on installing Oracle 7.2.2 on a HP9000 K200 dual processor
> machine. The machine is currently equipped with three disk in an LVM
> (logical volume manager) configuration.
> There's 2 ways we could distribute datafiles/tablespaces over the disks.
> Either we explicitly put different tablespaces on different logical volumes
> that reside on different disks, or we create a new logical volume striped
> over all 3 disks especially for oracle datafiles and place all datafiles in
> there.
> Hans anyone ever done any performance comparisons concerning those 2
> configurations? Any recommendations are appreciated.
>
> HP-UX 10.01 stripes are 4MB in size each..in case that matters.
>
> dave
>
> --
> David-Michael Lincke Institute for Information Management at USG
> EMail: dlincke_at_sgcl1.unisg.ch
> URL: http://www-iwi.unisg.ch/about/team/dal.htmlIt has been nearly a year since I last worked with HP, but at that time
LVM did its striping the same way Oracle did. If you have three 100m stripes comprising you TS, LVM fills the first stripe and then moves on to the second stripe and the third stripe. I don't see where this buys you any performance improvements. Unless LVM has changed the way the do striping, I would just use your basic rules of thumb to spread your files across the disks.

-- 
-------------------------------
| Phillip Whitcomb            |
| Gordon Food Service         |
| P.O. Box 1787               |
| 333 Fiftieth Street, SW     |
| Grand Rapids, MI 49501      |
| pwhitcom_at_gfs.com            |
-------------------------------