RE: How would you layout the files?

From: Michael Fontana <>
Date: Mon, 8 Dec 2008 15:57:56 -0600 (CST)
Message-ID: <>

Being that this appears to be a 2002 solution, it's not so bad. I would look at your OFA guidelines for disk placement in an 8i administrators guide. You're going to want to keep the redo away from the datafiles, and make sure you have multiple copies of same. Do all that and then pray you don't have a significant hardware failure, all the while, having good recovery procedures in place with measurably tested results; inform the client as to expectations along those lines, as well as performance, and you'll be fine.      

From: [] On Behalf Of Brian
Sent: Monday, December 08, 2008 3:51 PM
Subject: How would you layout the files?  

Say you have a client that for political reasons only bought 1 single server with 6 internal disks (the first 2 of which are RAID-1'd for the OS). Because you cannot apply any reasonable sense that the client should really look for better server/storage options (i.e., change the client's mind), how would you install Oracle 10g Enterprise Release 2? The underlying OS is Windows 2003 Enterprise Server 64-bit and the hardware is Dell PowerEdge 2950 with 8GB RAM. The disks are 15K 160GB disks. The actual db size is 100GB with about 100 end users and a peak redo rate of less than 100K/second. Again, you cannot tell the client to purchase new storage or a better server. So working with what you have, how would you RAID the remaining disks and layout the Oracle binaries, controlfiles, redo logs, archive logs (yes, archiving will be enabled), and datafiles? RAID options to RAID-10 are available. Emails offering RAID-5 solutions will be auto-deleted. :)  

Looking forward to the discussion,


Received on Mon Dec 08 2008 - 15:57:56 CST

Original text of this message