Oracle Server Configuration

[cadence]

Hello Experts,

I am fairly new at this... I have been working with the installation of Oracle - Exporting and Importing and Migration for the last year off and on. I have built the Server from scratch that Oracle is now running on. We built a new server, installed 8.1.6 Oracle and migrated an 8.0.5 DB to it last year at this time. I have just built another Server, and we are in the process of migrating to 8.1.7 and Windows 2K. The department is planning on purchasing a new Server right away in order to get started on 2002 planned move to this new Oracle Server and a switchover of Servers in general.

My question is - with the knowledge you have of oracle- What sort of suggestions do you have for the hardware configuration for a Windows 2000K Server? To put in perspective what they are looking at purchasing... The proposed configuration is:

2 Pentium 3 Processors of 1 G each
2 Drives of RAID #1 for the System
8 Drives for RAID #10 for the Database
Each of the drives would be 36G and hotswappable

I have seen many references to 'separating' Datafiles and relogs, control files, etc. within the Database configuration. Should these 8 RAID Drives be divided into 2 "Paks" -each with a controller for maximum performance and recovery? - with specific items on each?

Do any of you have any suggestions or recommendations concerning this configuration ? (RAID # - Number of Drives - # of processors - partitianing for best Performance / Recovery - )

Any comments will be appreciated

Thanks so much

 

[jcote]

I would suggest that you do a search in Metalink with the keywords "raid" and "configuration". The are a lot of very good documents that is aimed at answering the kind of questions you are asking resulting from that search (97597.1,227460.999 for example).
I don't know the content of them that well. I just know that the redologs should not be on RAID 5 (mainly beacause you write a lot to them).
Another thing, concentrate on memory instead of CPU!!!!