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

Home -> Community -> Mailing Lists -> Oracle-L -> am I out to lunch or drunk or something?

am I out to lunch or drunk or something?

From: Bowes, Chris <Chris.Bowes_at_kosa.com>
Date: Tue, 1 Aug 2000 11:49:38 -0400
Message-Id: <10576.113491@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_01BFFBD0.1C8CD828
Content-Type: text/plain;

        charset="iso-8859-1"

Hi everyone,

    I need a sanity check. I was asked via email by a friend what the amount of RAM on an HP9000 (hpux) should be considering the following:

# of bases on server: 1
Total size of base: Roughly 1G
Total number of users: 8-12
Not a datawarehouse, no options like parallel server or anything and a canned app on the front.

Oracle version 8i enterprise edition.

My reply was that it was a very rough estimate, but I would think that 500M was sufficient for the machine and that Oracle would take up 300M in the SGA or so.

I get a reply that their DBA said at least 1.5 g memory or more. Now I have 4 bases on one HP-ux server that total 20+ gig space and over 100 users and the Machine has 750M total memory for bases, processes and all. They run just fine. Fast response and all.

Am I just out in left field here? I know it isn't easy sizing a server with basically no information by phone, but I thought (given the parameters) that 500M was a decent estimate. Anyone?

--Chris
Chris.Bowes_at_Kosa.com

------_=_NextPart_001_01BFFBD0.1C8CD828
Content-Type: text/html;

        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>am I out to lunch or drunk or something?</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2 FACE=3D"Arial">Hi everyone,</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;&nbsp;&nbsp; I need a sanity =
check.&nbsp; I was asked via email by a friend what the amount of RAM = on an HP9000 (hpux) should be considering the following:&nbsp; =
</FONT></P>

<P><FONT SIZE=3D2 FACE=3D"Arial"># of bases on server: 1</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Total size of base:&nbsp; Roughly =
1G</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Total number of users:&nbsp; =
8-12</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Not a datawarehouse, no options like =
parallel server or anything and a canned app on the front.</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">Oracle version 8i enterprise =
edition.</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">My reply was that it was a very rough =
estimate, but I would think that 500M was sufficient for the machine = and that Oracle would take up 300M in the SGA or so.&nbsp; </FONT></P>

<P><FONT SIZE=3D2 FACE=3D"Arial">I get a reply that their DBA said at =
least 1.5 g memory or more.&nbsp; Now I have 4 bases on one HP-ux = server that total 20+ gig space and over 100 users and the Machine has = 750M total memory for bases, processes and all.&nbsp; They run just = fine.&nbsp; Fast response and all.</FONT></P>

<P><FONT SIZE=3D2 FACE=3D"Arial">Am I just out in left field =
here?&nbsp; I know it isn't easy sizing a server with basically no = information by phone, but I thought (given the parameters) that 500M = was a decent estimate.&nbsp; Anyone?</FONT></P>

<P><FONT SIZE=3D2 FACE=3D"Arial">--Chris</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Chris.Bowes_at_Kosa.com</FONT>
Received on Tue Aug 01 2000 - 10:49:38 CDT

Original text of this message

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