Re: Optimal hard disk layout for Oracle

Hi,
Since Temp and Rollbacks are almost all writes you may want to put them on a mirror set rather than Raid 5. There is a bit of a write penalty but not a major one.

_Ernie
----- Original Message -----
From: "Helmut Daiminger" <hdaiminger_at_vivonet.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, September 01, 2000 6:08 PM Subject: Optimal hard disk layout for Oracle

> Hi!
>
> We are about to get a new database server and my supervisor wants me to
> specify the hard disk layout. It is a given that we wanna go with RAID 5.
So
> here is what I'm thinking about:
>
> Disk 1: Operating system + Oracle software
> Disk 2: Online Redo Logs
> Disk 3: Online Redo logs (mirrored)
> Disk 4: archived redo logs
> Disk 5-8: Oracle data files (i.e data + index tablespaces, temp
tablespaces,
> rollback segments)
>
> Disks 1-4 will be 'stand-alone' disks (i.e. no RAID or mirroring). Disks
5-8
> will be in a RAID 5 array.
>
> Do you think it would be beneficial to add like another disk (e.g. place
> rollback segments or temp tablespace on a separate disk)?
>
> Any input would be appreciated.
>
> Thanks,
> Helmut
>
> --
> Author: Helmut Daiminger
> INET: hdaiminger_at_vivonet.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Fri Sep 01 2000 - 15:49:29 CDT