best raid configuration for oracle on solaris

From: Cristian S. <cs277_at_columbia.edu>
Date: Sat, 21 Jul 2001 21:34:42 GMT
Message-ID: <537e2d08.0107121359.1d18ebc1@posting.google.com>

Hi,

I have this application using Oracle 8i on solaris 8. The database is an OLTP type with read/write ratio of 75/25.

We just got a disk array with 12 x 9 GB drives where we want to move the database and I want to make sure we set it up right from the start. We have one oracle instance with one tablespace where all the action is. The disk array is only used by this application so space is not a concern (raid 0+1 or 1 are preffered to raid 5).

Below is my proposed setup for the drives. Please let me know if something must be changed.

Disks 1-4: RAID 0+1: datafiles, rollback segments, control files

Disks 5-6: RAID 1: redo logs

Disks 7-8: RAID 1: system and index tablespaces, archive logs, backups

Disks 9-10: RAID 1: application code for oracle

Disk 11: No RAID: TEMP tablespace

Disk 12: Hot spare

Thanks. Received on Sat Jul 21 2001 - 16:34:42 CDT