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

Hi

I think you're quite right. I'm not in charge of major league databases=  here but
the one you describe runs fine on a laptop with a handful of ram

Jack

"Bowes, Chris" <Chris.Bowes_at_kosa.com>@fatcity.com on 08/01/2000 05:55:1= 3 PM

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:
Subject: am I out to lunch or drunk or something?

Hi everyone,

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

# of bases on server: 1
Total size of base:=A0 Roughly 1G
Total number of users:=A0 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 SG= A or so.

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

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

--Chris
Chris.Bowes_at_Kosa.com

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
De informatie verzonden met dit E-mail bericht is uitsluitend bestemd v= oor
de geadresseerde. Gebruik van deze informatie door anderen dan de geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreid= ing
en/of verstrekking van deze informatie aan derden is niet toegestaan. Ernst & Young staat niet in voor de juiste en volledige overbrenging va= n de
inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan.
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
The information contained in this communication is confidential and may=  be
legally privileged. It is intended solely for the use of the individual=  or
entity to whom it is addressed and others authorised to receive it. If = you
are not the intended recipient you are hereby notified that any disclos= ure,
copying, distribution or taking any action in reliance on the contents=  of
this information is strictly prohibited and may be unlawful. Ernst & Young is neither liable for the proper and complete transmission of th= e
information contained in this communication nor for any delay in its receipt.
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
Received on Tue Aug 01 2000 - 14:13:51 CDT