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: am I out to lunch or drunk or something?

RE: am I out to lunch or drunk or something?

From: Bowes, Chris <Chris.Bowes_at_kosa.com>
Date: Tue, 1 Aug 2000 14:02:37 -0400
Message-Id: <10576.113507@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_01BFFBE2.AD6A4CCE
Content-Type: text/plain;

        charset="iso-8859-1"

There is an app on the clients that is installed in the base. According to the friend I have there, it is "just a basic warehouse app".

--Chris
Chris.Bowes_at_Kosa.com

-----Original Message-----
From: Winnie_Liu_at_infonet.com [mailto:Winnie_Liu_at_infonet.com] Sent: Tuesday, August 01, 2000 1:55 PM
To: Multiple recipients of list ORACLE-L Subject: Re: am I out to lunch or drunk or something?

Chris,

Is this box going to be delicated for the Oracle database? No canned apps running against it?

Winnie

"Bowes, Chris" <Chris.Bowes_at_kosa.com> on 08/01/2000 09:55:12 AM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Winnie Liu/HQ/ISC)

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_01BFFBE2.AD6A4CCE
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>RE: am I out to lunch or drunk or something?</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2>There is an app on the clients that is installed in =
the base.&nbsp; According to the friend I have there, it is &quot;just = a basic warehouse app&quot;.&nbsp; </FONT></P>

<P><FONT SIZE=3D2>--Chris</FONT>
<BR><FONT SIZE=3D2>Chris.Bowes_at_Kosa.com</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Winnie_Liu_at_infonet.com [<A =
HREF=3D"mailto:Winnie_Liu_at_infonet.com">mailto:Winnie_Liu_at_infonet.com</A>= ]</FONT>
<BR><FONT SIZE=3D2>Sent: Tuesday, August 01, 2000 1:55 PM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: Re: am I out to lunch or drunk or =
something?</FONT>
</P>
<BR>
<BR>

<P><FONT SIZE=3D2>Chris,</FONT>
</P>

<P><FONT SIZE=3D2>Is this box going to be delicated for the Oracle =
database? No canned apps</FONT>
<BR><FONT SIZE=3D2>running against it?</FONT>
</P>

<P><FONT SIZE=3D2>Winnie</FONT>
</P>
<BR>
<BR>
<BR>
<BR>

<P><FONT SIZE=3D2>&quot;Bowes, Chris&quot; &lt;Chris.Bowes_at_kosa.com&gt; =
on 08/01/2000 09:55:12 AM</FONT>
</P>

<P><FONT SIZE=3D2>Please respond to ORACLE-L_at_fatcity.com</FONT>
</P>

<P><FONT SIZE=3D2>To:&nbsp;&nbsp; Multiple recipients of list ORACLE-L =
&lt;ORACLE-L_at_fatcity.com&gt;</FONT>
<BR><FONT SIZE=3D2>cc:&nbsp;&nbsp;&nbsp; (bcc: Winnie =
Liu/HQ/ISC)</FONT>
</P>
<BR>
<BR>
<BR>
<BR>

<P><FONT SIZE=3D2>Hi everyone,</FONT>
</P>

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

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

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

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

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

<P><FONT SIZE=3D2>Am I just out in left field here?&nbsp; I know it =
isn't easy sizing a server</FONT>
<BR><FONT SIZE=3D2>with</FONT>
<BR><FONT SIZE=3D2>basically no information by phone, but I thought =
(given the parameters)</FONT>
<BR><FONT SIZE=3D2>that</FONT>
<BR><FONT SIZE=3D2>500M was a decent estimate.&nbsp; Anyone?</FONT>
Received on Tue Aug 01 2000 - 13:02:37 CDT

Original text of this message

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