Re: Need Oracle Hardware recommendation

From: Mark Rosenbaum <mjr_at_netcom.com>
Date: 1997/01/11
Message-ID: <mjrE3upL6.J6x@netcom.com>#1/1

In article <E3qB8u.EyI_at_asuvax.eas.asu.edu>, System Manager <system_at_asuvax.eas.asu.edu> wrote:
>I need some recommendations for hardware (CPU (type and number of),
>memory, best disk setup (RAID,...), etc.) for setting up a new Oracle
>database which will have approx. 100 concurrent users. The database
>size will start at 400GB. A Unix box is preferred, but not a
>requirement. Any recommendations?
>
>Thanks!
>

There are a number of good boxes out there many will perform with your initial requirements. Depending, of course, on what type of users, how often they query/update ... Also if you a planning on expanding particularly to over 2 Terabytes then I would strongly recommend a 64 bit OS DEC or SGI. As far as RAID goes RAID 5 will be you cheapest for disk but will give poor small block write performance. RAID 0+1 will give good small block write performance but will require twice the disk. If you can partition you DB into current Read Write tables and historical Read only tables you can combine the RAIDs effectively. With 400 GB of disk RAID will be necessary.

Feel free to contact me directly

Mark Rosenbaum			Otey-Rosenbaum & Frazier, Inc.
mjr_at_netcom.com			Consultants in High Performance and
(303) 727-7956			Scalable Computing and Applications
POB 1397			ftp://ftp.netcom.com/pub/mj/mjr/resume/

Boulder CO 80306 Received on Sat Jan 11 1997 - 00:00:00 CST