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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Hardware requirements for Oracle

RE: Hardware requirements for Oracle

From: Alex Hillman <alex_hillman_at_physia.com>
Date: Thu, 4 Jan 2001 18:47:08 -0500
Message-Id: <10731.125798@fatcity.com>


This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C076A8.A67D2890
Content-Type: text/plain;

        charset="windows-1252"

I remember recommendation not to have more then 2 batch jobs running simultaniously per 1 processor.

Alex Hillman

-----Original Message-----
From: dgoulet_at_vicr.com [mailto:dgoulet_at_vicr.com] Sent: Thursday, January 04, 2001 9:46 AM To: Multiple recipients of list ORACLE-L Subject: Re:Hardware requirements for Oracle

Sherrie,

    HUMM, very nice question which will probably start a war, but what the heck.
 OK, Does Oracle like multiple processors? Does a fire appreciate gasoline?

answer, Yes. But more to the point, mainly because we've used both single and
multiple processors (up to 4) around here and still do. Oracle will run nicely
on one or more processors. What it REALLY likes is lots of memory (the more the
better) and lots of disk io. Therefore, with power unit pricing in mind, use a
high end single processor, double the memory your thinking of and fill the box
with SCSI cards. A good 100MB network card is very helpful too.

As an example, we ran(until recently) an assembly line which supported 200 clients on an HP 9000 K460 with one 400MHZ (I believe) processor. The box had
2.5 GB of ram & 8 SCSI cards into an EMC array. Ran like crazy until HP gave us
a better deal. Now were on a L2000 with 1 600MHZ processor with only 2 SCSI cards. We're just leaving the noise level on the processor, but wait io (namely
the lack of disk io capacity) is raising fast. We're planning on 4 more SCSI
cards.

So, get the Unix box, a good 2GB of RAM and 4 or more SCSI cards. The single
processor will hold the load, believe me.

Dick Goulet

____________________Reply Separator____________________
Author: Sherrie.Kubis_at_swfwmd.state.fl.us
Date:       1/4/2001 5:55 AM

Our site is acquiring third-party software budgeting software called BRASS, which uses an Oracle database. Our management is considering NT or UNIX, and for various reasons I am pushing UNIX. BRASS will have four or five users throughout the year, but for one month during the budget cycle will have up to 100 users. The planner specing out the hardware for this system is proposing a dual processor because he says that Oracle 'likes' a dual processor. I not very hardware knowledgeable, but am questioning whether or not this is needed. With power unit pricing, the number of processors drastically goes up. I have searched MetaLink and everywhere else that I can find, but nothing gives any hard facts on when a dual processor should be considered, or if it is required.

Any insights or direction to information would be greatly appreciated.

Sherrie Kubis
Southwest Florida Water Management District 2379 Broad Street
Brooksville, FL 34604
352.796.7211 Ext 4033
Fax: 352-754-6776
sherrie.kubis_at_swfwmd.state.fl.us

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Sherrie.Kubis_at_swfwmd.state.fl.us

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: dgoulet_at_vicr.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

------_=_NextPart_001_01C076A8.A67D2890
Content-Type: text/html;
	charset="windows-1252"


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1252">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2448.0">
<TITLE>RE: Hardware requirements for Oracle</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=2>I remember recommendation not to have more then 2 batch jobs running simultaniously per 1 processor.</FONT>
</P>

<P><FONT SIZE=2>Alex Hillman</FONT>
</P>

<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: dgoulet_at_vicr.com [<A HREF="mailto:dgoulet_at_vicr.com">mailto:dgoulet_at_vicr.com</A>]</FONT>
<BR><FONT SIZE=2>Sent: Thursday, January 04, 2001 9:46 AM</FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=2>Subject: Re:Hardware requirements for Oracle</FONT>
</P>
<BR>

<P><FONT SIZE=2>Sherrie,</FONT>
</P>

<P><FONT SIZE=2>&nbsp;&nbsp;&nbsp; HUMM, very nice question which will probably start a war, but what the heck.</FONT>
<BR><FONT SIZE=2>&nbsp;OK, Does Oracle like multiple processors?&nbsp; Does a fire appreciate gasoline? </FONT>
<BR><FONT SIZE=2>answer, Yes.&nbsp; But more to the point, mainly because we've used both single and</FONT>
<BR><FONT SIZE=2>multiple processors (up to 4) around here and still do.&nbsp; Oracle will run nicely</FONT>
<BR><FONT SIZE=2>on one or more processors.&nbsp; What it REALLY likes is lots of memory (the more the</FONT>
<BR><FONT SIZE=2>better) and lots of disk io.&nbsp; Therefore, with power unit pricing in mind, use a</FONT>
<BR><FONT SIZE=2>high end single processor, double the memory your thinking of and fill the box</FONT>
<BR><FONT SIZE=2>with SCSI cards.&nbsp; A good 100MB network card is very helpful too.</FONT>
</P>

<P><FONT SIZE=2>As an example, we ran(until recently) an assembly line which supported 200</FONT>
<BR><FONT SIZE=2>clients on an HP 9000 K460 with one 400MHZ (I believe) processor.&nbsp; The box had</FONT>
<BR><FONT SIZE=2>2.5 GB of ram &amp; 8 SCSI cards into an EMC array.&nbsp; Ran like crazy until HP gave us</FONT>
<BR><FONT SIZE=2>a better deal.&nbsp; Now were on a L2000 with 1 600MHZ processor with only 2 SCSI</FONT>
<BR><FONT SIZE=2>cards.&nbsp; We're just leaving the noise level on the processor, but wait io (namely</FONT>
<BR><FONT SIZE=2>the lack of disk io capacity) is raising fast.&nbsp; We're planning on 4 more SCSI</FONT>
<BR><FONT SIZE=2>cards.</FONT>
</P>

<P><FONT SIZE=2>So, get the Unix box, a good 2GB of RAM and 4 or more SCSI cards.&nbsp; The single</FONT>
<BR><FONT SIZE=2>processor will hold the load, believe me.</FONT>
</P>

<P><FONT SIZE=2>Dick Goulet </FONT>
</P>

<P><FONT SIZE=2>____________________Reply Separator____________________</FONT>
<BR><FONT SIZE=2>Author: Sherrie.Kubis_at_swfwmd.state.fl.us</FONT>
<BR><FONT SIZE=2>Date:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/4/2001 5:55 AM</FONT>
</P>

<P><FONT SIZE=2>Our site is acquiring third-party software budgeting software called BRASS,</FONT>
<BR><FONT SIZE=2>which uses an Oracle database.&nbsp; Our management is considering NT or UNIX,</FONT>
<BR><FONT SIZE=2>and for various reasons I am pushing UNIX.&nbsp; BRASS will have four or five</FONT>
<BR><FONT SIZE=2>users throughout the year, but for one month during the budget cycle will</FONT>
<BR><FONT SIZE=2>have up to 100 users.&nbsp; The planner specing out the hardware for this system</FONT>
<BR><FONT SIZE=2>is proposing a dual processor because he says that Oracle 'likes' a dual</FONT>
<BR><FONT SIZE=2>processor.&nbsp; I not very hardware knowledgeable, but am questioning whether</FONT>
<BR><FONT SIZE=2>or not this is needed.&nbsp; With power unit pricing, the number of processors</FONT>
<BR><FONT SIZE=2>drastically goes up.&nbsp;&nbsp;&nbsp; I have searched MetaLink and everywhere else that I</FONT>
<BR><FONT SIZE=2>can find, but nothing gives any hard facts on when a dual processor should</FONT>
<BR><FONT SIZE=2>be considered, or if it is required.</FONT>
</P>

<P><FONT SIZE=2>Any insights or direction to information would be greatly appreciated.</FONT>
</P>
<BR>
<BR>
<BR>

<P><FONT SIZE=2>Sherrie Kubis</FONT>
<BR><FONT SIZE=2>Southwest Florida Water Management District</FONT>
<BR><FONT SIZE=2>2379 Broad Street</FONT>
<BR><FONT SIZE=2>Brooksville, FL&nbsp;&nbsp; 34604</FONT>
<BR><FONT SIZE=2>352.796.7211 Ext 4033</FONT>
<BR><FONT SIZE=2>Fax:&nbsp;&nbsp; 352-754-6776</FONT>
<BR><FONT SIZE=2>sherrie.kubis_at_swfwmd.state.fl.us</FONT>
</P>
<BR>

<P><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Please see the official ORACLE-L FAQ: http://www.orafaq.com</FONT>
<BR><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Author: </FONT>
<BR><FONT SIZE=2>&nbsp; INET: Sherrie.Kubis_at_swfwmd.state.fl.us</FONT>
</P>

<P><FONT SIZE=2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=2>San Diego, California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet access / Mailing Lists</FONT>
<BR><FONT SIZE=2>--------------------------------------------------------------------</FONT>
<BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail message</FONT>
<BR><FONT SIZE=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT>
<BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB ORACLE-L</FONT>
<BR><FONT SIZE=2>(or the name of mailing list you want to be removed from).&nbsp; You may</FONT>
<BR><FONT SIZE=2>also send the HELP command for other information (like subscribing).</FONT>
<BR><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Please see the official ORACLE-L FAQ: http://www.orafaq.com</FONT>
<BR><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Author: </FONT>
<BR><FONT SIZE=2>&nbsp; INET: dgoulet_at_vicr.com</FONT>
</P>

<P><FONT SIZE=2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=2>San Diego, California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet access / Mailing Lists</FONT>
<BR><FONT SIZE=2>--------------------------------------------------------------------</FONT>
<BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail message</FONT>
<BR><FONT SIZE=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT>
<BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB ORACLE-L</FONT>
<BR><FONT SIZE=2>(or the name of mailing list you want to be removed from).&nbsp; You may</FONT>
Received on Thu Jan 04 2001 - 17:47:08 CST

Original text of this message

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