Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Hardware specification for database server !!!

Re: Hardware specification for database server !!!

From: Mladen Gogala <mgogala_at_earthlink.net>
Date: Mon, 26 Nov 2001 13:18:21 GMT
Message-ID: <pan.2001.11.26.08.18.15.104.15934@earthlink.net>


In article <9ttbcp$pt4$1_at_sunce.iskon.hr>, "Đuro Dretvić" <Djuro.Dretvic_at_infodom.hr> wrote:

> Greetings !!!
>
> I need help for hardware specification of database server at my company.
> We are
> relatively small software development company. We have 60 employes.
>
> Here are our requirements:
>
> 1. 30 developers (all on Oracle). (Oracle CASE Designer, Oracle Forms,
> Oracle Portal)
> 2. Windows 2000 OPSYS
> 3. Two databases : (8.1.7. with possibility of upgrade to 9.1.1)
> a) Development
> b) Production (only for internal use)
> 4. Optimal perforamance
> 5. Hardware should be from known manufactor. (Brand name) 6. My request
> as DBA: I don't wan't to see my developers at office with problem that a
> database works slow.
>
> What do you suggest ?
>
> We intended to buy hardware form Hewlett Packard. Is there recommendation
> about hardware specification from Oracle on metalink .
>
> Thanks for you answers in advace.
> Regards Djuro.
>
> ? Number of processors:
> ? Quantity of RAM:
> ? Number of disks:
> ? Size of disks:
> ? RAID (Hadrware or software):
> ? ...

Everything is nice exept requesting that the OS has to be Win2000. One little HP 9000N could run all that without a problem. It is a known fact that neither NT nor Win2000 shine when it comes to SMP. HP-UX, Solaris, AIX and even Linux will beat any NT version hands down on an SMP box. Those SMP R6000 boxes are rather inexpensive and extremely powerfull as well as HP and SUN boxes. Solaris is a marvellous development environment with little things like truss and tcpdump built into OS. Here is my recommendaton:

4 CPUS
4 GB RAM
6 10GB drives (SW, log files,system TBS, temp, RBS) Any number of big disk drives for data and indexes. USe locally managed tablespaces wherever you can.

As for RAID, that is primarily a financial decision, which is made based on whether youcan tolerate outage and how long can the system be down. On the other hand coold gadgets like Symmetrix can make your life and backups much simpler. EMC products are rather pricey, though.

My company (Oxford Health Plans, Trumbull CT, www.oxhp.com) is running 4-way OPS on 4 HP class N boxes and we have a separate 2-way OPS for development. The underlying disks are on EMC Symmetrix boxes and we are running 4000 concurrent users and 200 developers (using CASE, Oracle*Forms, FORTE and Java). We are a Unix shop. NT and Win2000 are departmental print servers and file servers, not database servers.

-- 
Mladen Gogala
Received on Mon Nov 26 2001 - 07:18:21 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US