I would choose either a or c depending on your applications. c will probably
give the best throughput, suitable for OLAP.
"Guy Dallaire" <gd-newsgroups_at_spamex.com> wrote in message
news:1xQpb.641$143.28461_at_news20.bellglobal.com...
> Say you have 8 disks in a hardware raid controller on which you want to
> place oracle datafiles. Your redo logs are duplexed on another separate
pair
> of disks. You want mirroring
>
> What is the best scenario:
>
> a) Create 4 mirrors of two disks each, and treat each mirror as separate
> devices, place indexes and data files on separate disk, juste like on a
> regular disk.
>
> b) Create 2 stripped mirrors of 4 disks each, one for indexes, one for
> tables.
>
> c) Create 1 big stripped mirror with the 8 disks and place all datafiles
on
> it, regardless of types of segments.
>
> The RAID Array is a sun storedge 3310 with 2 controllers (512 Mb cache)
>
>
>
>
>
>
Received on Tue Nov 04 2003 - 19:24:57 CST
