Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: best raid configuration for oracle on solaris

Re: best raid configuration for oracle on solaris

From: Przemek Bąk <przemolicc_at_poczta.fm.-no-spam>
Date: 14 Jul 2001 12:15:04 GMT
Message-ID: <slrn9l0dbm.3e9.przemolicc@przemek.pgf.com.pl>

Cristian S. <cs277_at_columbia.edu> wrote:
> 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

I would go with:

1-10: RAID 0+1
12 : hotspare

Remember that if you make big stripe you will gain on performance. And having one filesystem (but making u01, u02, etc.. on it) you spread load on all disks. And you don't care about space (almost ;-) )

przemol Received on Sat Jul 14 2001 - 07:15:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US