Windows2003 Server Config for Oracle 10g

We're awaiting a Dell 2900 PowerEdge machine with Win2003. We plan to load Oracle 10g Standard Edition and import our databases from the current 'production' machine, currently running Oracle8i. The main application is a networked, multi-user data modeling tool which uses Oracle as its data repository; and empty databases from the DDL generated from the modeling tool's physical data model segment. The two main Oracle databases themselves are 8 GB and 500 MB in size. It's possible that we may have to support MS SQLServer on the new machine, too.

The PE2900 is configured with 8 GB memory; 2x73GB mirrored root SAS drives on channel0; and 8x146 GB SAS drives in 2 RAID 10 arrays with each stripe set of 4 drives on separate channel of the I/O card.

The root disks will be logical C: drive, others logical D: drive.

Is this the optimal configuration for this hardware set? Can anything be done better?

Also, this is my first exposure to Oracle, though I'm a veteran DBA with other major DBMSes. Any words for the wise in configuring the new instance? Received on Wed Feb 07 2007 - 15:41:01 CST