RE: Optimal hard disk layout for Oracle

On Sam, 02 Sep 2000, Figueiredo, Pedro wrote:
> Hi,
>
> I believe Raid 5 is not very recommended with OLTP environments.
> If you can use Raid 0 + 1 in a cluster solution it would be the ideal
> solution.
> Do some more research on the subject...
>
> If you have the possibility, use raw devices (at least) for the redo log
> files.
> Use forcedirectio on Oracle database devices (Sun Solaris terminology, other
> platforms should have similar possibility). No need to have both Oracle and
> OS buffering disk writes...
>

... And oracle recommends mirroring/multiplexing the archived redo logs too. (How many disks do you have? :-)

oli

> Best regards
>
> Pedro Figueiredo
>
> -----Original Message-----
> Sent: sábado, 2 de Setembro de 2000 1:50
> To: Multiple recipients of list ORACLE-L
>
>
> 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 -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Friday, September 01, 2000 6:08 PM
>
>
> > 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).
> >
>
> --
> Author: Ernest Simard
> INET: simard_at_sonoma.edu
>
> 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).
> --
> Author: Figueiredo, Pedro
> INET: PFigueiredo_at_europeantelecom.at
>
> 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).

-- 
---

Oliver Artelt, System- und Datenbankadministration
---------------------------------------------------------------
  cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg
telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 10
   email: oli@cubeoffice.de # web: http://www.cubeoffice.de