Re: 4 x 15Krpm drives or 6 x 10Krpm drives?

I think you will get better performance with the 6x10k config. Plus, depending on the drive sizes, you will have more storage space as well. Are the drive capacities the same in each config, or are the 15k drives larger?

Why do you need to do it this way? I am cringing at the thought of having to recover this system from a serious crash.

For the relatively low cost, I would throw in an 18gig boot drive (I believe that is the smallest Dell is offering on their servers now), or two if you want to mirror the volume. Then install your oracle on the larger drive config.

If you want my personal opinion, I would even break out the Oracle installation into separate volumes. If you go by Oracles rules (which I am trying to recall from memory), the Oracle binaries should reside on one drive, each control file should reside on a separate drive, each redo log member should reside on a separate drive, archive logs should be on yet another drive, and datafiles should be on their own drive as well.

Of course, I have never configured a database this way (incredible waste of space), but I have reorganized the database files amongst multiple drives, minimizing the number of drives while maximizing safety. I install Oracle on the boot drive alongside the OS and then mirror that volume. I then have three drives, each one containg a member of each multiplexed redo log group, as well as one of the control files. I then have a drive that contains my archive logs, which is then mirrored. And finally I have a RAID 0+1 set that contains my data and index tablespace files.

As an alternative, you can also put your archive logs on the same mirrored volume as the OS and Oracle installation, but I advise against it. Nothing like having your archive logs filling up your boot volume.

Of course, this is just my opinion, you can do it any way you please.

On Tue, 26 Feb 2002 15:30:01 -0800, "Gonzo" <idonthaveemail_at_notime.ever> wrote:

>DELL PE2500 W2000 Server, Oracle 8.17 standard, 10 users, 500 transactions
>per day (Accounting system)
>
>Boot files, O/S, Oracle, Data, Indexes etc all residing on one logical
>volume.
>
>Which is preferabe:
>
>a. 4 x 15Krpm drives: 2 Mirrored Stripe sets of 2 drives each
>b. 6 x 10Krpm drives: 2 Mirrored Stripe sets of 3 drives each
>
>Thanks in advance!
>
>
>
>
Received on Tue Feb 26 2002 - 22:20:51 CST