Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> am I out to lunch or drunk or something?
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"> 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: =
</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: Roughly =
1G</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Total number of users: =
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. </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. 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.</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">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?</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