Re: striped logical volume or explicitly assigned lv's for 7.3.2 on HP-UX 10.20?

David,
as many I/O channels to the many disks you have the better. The HP K series is a pretty good match for that when configured properly for ORACLE.

Best approach is to use LVM, and stripe, stripe, stripe. Stripe vertical and horizontal across drives with LVM and ORACLE datafiles.

8K blocks are good for an OLAP of DSS system

Besure to keep redo logs and rollbacks of any raid 5 devices. RAID 0+1 works best, but takes more disks.

With this method administration is simplified and you get an aproximate 10-15% performance increase.

Steve Lemme
DBA
Motorola

 The question now is if we should explicitly assign datafiles, redo logs and
> rollback segments to several different logical volumes each of them
> residing on a different physical volume or if we should just create one
> large logical volume striped across all available disks to hold the whole
> database.
> Any recommendations on which configuraztion to go with is appreciated.
> Transaction volume on the database will be rather low. Most activity will
> consist of queries.
>
> The database will be spread over 4 disk drives. If striping should be
> recommended over explicit assignment which strip size (8k or bigger) would
> be best?
>
> If the speedup achievable by explicit manual assignment of files to disks
> compared to a striped logical volume should be within 10-15 percent we'd
> take the striping approach due to the lower administrative overhead
> required.
>
> thanks,
> dave
>
> --
> David-Michael Lincke
 

-- 
When you are in it up to your ears....
Keep your mouth shut!
rp1399_at_email.sps.mot.com