Re: Need advice !!

I won't flame you give the caveat that only 4 disks are available. But it certainly will not be a good performer.

Daniel Morgan

Niall Litchfield wrote:

> I'm expecting to be flamed for this advice (at least the second bit).
>
> Part 1). Please consider buying (many) more disks. 4 disks isn't anywhere
> near enough for a high performing database disk subsystem. an example might
> be
>
> 2 disks - os & swap
> 2 disks - oracle sw
> 4 disks - data files 1
> 4 disks - data files 2
> 2 disks - redo logs 1
> 2 disks - redologs 2
> 2 disks - archived redo
>
> Part 2)
> If you can only keep to the 4 disks you might as well put the whole lot on
> RAID5. You'll get reasonable performance with the controller you have
> without too high a raid overhead in terms of disks. This solution is most
> definitely sub-optimal but it is easy and straightforward.
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
>
> ******************************************
> "Fernando Ruza" <fruza_at_yahoo.com> wrote in message
> news:3d8dfca3.0202040143.8512056_at_posting.google.com...
> > Hi,
> >
> > Thanks for reading this post.
> > I have a new Compaq ML370 server. I'm planning to have it as a
> > datawarehouse database with Oracle8i/9i and Linux RedHat 7.1.
> > This server has four hard disk (SCSI 18Gb each) with a Smart Array
> > Controller 5i which is able to do RAID 1 and 5.
> >
> > I need advice about the planning of the installation. How to
> > distribute the oracle database files amongs the disks for a good
> > performance. Is this planification important if I have RAID 5 ??
> >
> > Anyway, just ideas about how you would do the installation of an
> > Oracle datawarehouse database in this kind of server.
> >
> > Thanks in advance to any reply,
> >
> > Fernando Ruza
> > fruza_at_axial-tbg.com
Received on Mon Feb 04 2002 - 11:48:34 CST