Re: Need advice !!

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