RAID help

From: Joga Rao Nakka <joga_at_paradise.net.nz>
Date: Sat, 27 May 2000 00:45:01 +1200
Message-Id: <10509.106854@fatcity.com>

I got a problem. I was asked to tune the database as its performance very
  poor. Here is the existing database layout.

        Machine : IBM Netfinity 5500 M-20 with 2 x 550MHz processors.
        disks   : RAID5  disk array with 4 x 9.1 gigs (net  27 gigs)
  with additional scsi channel connected to DLT tape drive external
        OS      : WinNT 4.0 service pack 6
        Oracle  : 8i standard edition with one 8k block instance
        Application: web application through Story server

  The entire disk array is made into 2 logical drives. 5 gigs and 22 gigs
  OS and Oracle is installed on small logical drive and Data , index, RBS, TEMP,
  LOB tablespaces ,exports, REDOs and Archive logs are on 22 gigs logical volume.

  I advised the client to replace RAID5 with RAID0 + 1.   Unfortunately Hardware does not support. IBM guy clarified this.

  The client does not want to spend any amount for additional disks.   I left with two options :

1. To go for IBM enhanced RAID1 (striping + mirror)
2. Live with RAID5 In the above cases, Please suggest me for suitable database layout which will give improve present bottleneck of disk I/0 . Before tuning RDBMS and SQL, I would like to come to baseline compromise with database layout.

Does any one had came across RAID Enahanced 1 ...?

  I am new to Win NT on these boxes and RAID technology. Your help is very much appreciated. Received on Fri May 26 2000 - 07:45:01 CDT