Distribution of datafiles over disks vs. striped volume
From: David-Michael Lincke <dlincke_at_bandon.unisg.ch>
Date: 1996/02/01
Message-ID: <1996Feb1.220155.4122_at_sgcl1.unisg.ch>#1/1
Date: 1996/02/01
Message-ID: <1996Feb1.220155.4122_at_sgcl1.unisg.ch>#1/1
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.htmlReceived on Thu Feb 01 1996 - 00:00:00 CET