Re: Best disk/hardware Configuration (How To)

I would think that if you had several distinct drives instead of one BIG E: drive, you would be better able to place your datafiles to distribute the i/o (although spreading E: across multiple disks does this to a fair degree, you don't have quite as much fine control in terms of placement of files...which of the two is best depends on the number of datafiles, their sizes, tablespaces, and how the activity is spread). Placing one tablespace per 1-2 datafiles, monitoring the i/o, and then redistributing the datafiles so that all drives get approx the same amount of activity would then be possible.

I would isolate NT's swap space from the Oracle datafiles for sure. Same for the redo and archived redo logs (which should be mirrored if possible since if they are lost you can only recover up to your last full, cold backup) so that log switches/archiving don't impact the main database as much.

Svein-Egil Pettersen <svpett_at_sn.no> wrote in article <MPG.da31921cd2254d9989684_at_news.sn.no>...
> Hello!
> Our Company is new to Oracle and the NT Platform. Today
> we have 400+ OS/2 machines, we recently got ourselfs
> a Intel based server for Oracle 7.3 and Win NT V4.0.
>
> What is the best way to configure the harddisks
>
> Dual PPro 200Mhz
> 512 Mb ECC Ram
> 8 x 4,5 GB hotswap 7200 Rpm hardisks
> Oracle 7.3 Enterprise Server
> Windows Nt v4.0
> Mylex Multichannel Cached UltraWide SCSI
> This is what I have done:
>
> Win Nt, Oracle Exe's, Redologs on RAID1 (Mirroring) 2 disks, one usable.
> C: and D: (Redologs on D:)
>
> The rest of the disk is RAID5 for datafiles (one Large E: drive)
>
> IS this a good solution ???
> Should I split the RAID5 area in several Logical drives E: f: g: h:.....
 

> ???
> Can someone please recommend somthing else, or tell me what I
> an doing wrong here, and why ????
>
>
> Regards
> Svein-Egil Pettersen
> Joh-Data AS
> Oslo, Norway
>
> Email #1 : svpett_at_sn.no
> Email #2 : svpett_at_ibm.net
> Email #3 : 100445,1527 (Compuserve)
>
>
>
>
>
  Received on Wed Mar 26 1997 - 00:00:00 CST