Re: Need suggestions for filesystem config, spindle separation, striping for HP-UX/PeopleSoft

Just wondering why you are not proposing to mirror your redo logs or control files? You should, even if you have hardware mirroring or RAID.

As for the proposed file distribution: honestly, I can't comment beyond saying that 2 spindles isn't enough (and you knew that already!). Everything you do will be a compromise anyway, so yours is as good a performance-disaster-in-the-making as anything anyone else might propose!

I saw the stuff about striping data and indexes in your other post: as you realise, they are talking about situations where *reads* are taking place on indexes and then on tables. As you say, this is essentially a DSS solution, and as such is fine. Shame you have a hybrid! Only you can choose which way to slant things -and you appear to have favoured the DSS stuff, so that's fine.

Regards
HJR "John K. Hayes" <aikosys_at_earthlink.net> wrote in message news:3A8D7A2E.402B8101_at_earthlink.net...
> Here is (hopefully) a better copy of that table:
>
> Non-Striped:
> --------------------------------------------
> spindle1 spindle2
> ----------- ----------------------------
> o/s temp t/s
> oracle s/w redo logs (non-mirrored)
> system t/s control files (non-mirrored)
> rollback t/s dumps
> --------------------------------------------
>
>
> Striped:
> --------------------------------------------
> data t/s's
> index t/s's
> --------------------------------------------
>
>
Received on Fri Feb 16 2001 - 17:41:45 CST