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

--0__=tySuK9TbdXW4wsFaYmCsiDB1fqThrhFmJK6p9mopXakkkupSQEx5kkOr
Content-type: text/plain; charset=us-ascii Content-Disposition: inline

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)

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

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

--0__=tySuK9TbdXW4wsFaYmCsiDB1fqThrhFmJK6p9mopXakkkupSQEx5kkOr
Content-type: text/html;

        name="att1.htm"

Content-Disposition: attachment; filename="att1.htm"
Content-transfer-encoding: base64
Content-Description: Internet HTML

PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDMuMi8vRU4iPg0KPEhUTUw+ DQo8SEVBRD4NCjxNRVRBIEhUVFAtRVFVSVY9IkNvbnRlbnQtVHlwZSIgQ09OVEVOVD0idGV4dC9o dG1sOyBjaGFyc2V0PWlzby04ODU5LTEiPg0KPE1FVEEgTkFNRT0iR2VuZXJhdG9yIiBDT05URU5U PSJNUyBFeGNoYW5nZSBTZXJ2ZXIgdmVyc2lvbiA1LjUuMjY1MC4xMiI+DQo8VElUTEU+YW0gSSBv dXQgdG8gbHVuY2ggb3IgZHJ1bmsgb3Igc29tZXRoaW5nPzwvVElUTEU+DQo8L0hFQUQ+DQo8Qk9E WT4NCg0KPFA+PEZPTlQgU0laRT0yIEZBQ0U9IkFyaWFsIj5IaSBldmVyeW9uZSw8L0ZPTlQ+DQo8 L1A+DQoNCjxQPjxGT05UIFNJWkU9MiBGQUNFPSJBcmlhbCI+Jm5ic3A7Jm5ic3A7Jm5ic3A7IEkg bmVlZCBhIHNhbml0eSBjaGVjay4mbmJzcDsgSSB3YXMgYXNrZWQgdmlhIGVtYWlsIGJ5IGEgZnJp ZW5kIHdoYXQgdGhlIGFtb3VudCBvZiBSQU0gb24gYW4gSFA5MDAwIChocHV4KSBzaG91bGQgYmUg Y29uc2lkZXJpbmcgdGhlIGZvbGxvd2luZzombmJzcDsgPC9GT05UPjwvUD4NCg0KPFA+PEZPTlQg U0laRT0yIEZBQ0U9IkFyaWFsIj4jIG9mIGJhc2VzIG9uIHNlcnZlcjogMTwvRk9OVD4NCjxCUj48 Rk9OVCBTSVpFPTIgRkFDRT0iQXJpYWwiPlRvdGFsIHNpemUgb2YgYmFzZTombmJzcDsgUm91Z2hs eSAxRzwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTIgRkFDRT0iQXJpYWwiPlRvdGFsIG51bWJlciBv ZiB1c2VyczombmJzcDsgOC0xMjwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTIgRkFDRT0iQXJpYWwi Pk5vdCBhIGRhdGF3YXJlaG91c2UsIG5vIG9wdGlvbnMgbGlrZSBwYXJhbGxlbCBzZXJ2ZXIgb3Ig YW55dGhpbmcgYW5kIGEgY2FubmVkIGFwcCBvbiB0aGUgZnJvbnQuPC9GT05UPg0KPC9QPg0KDQo8 UD48Rk9OVCBTSVpFPTIgRkFDRT0iQXJpYWwiPk9yYWNsZSB2ZXJzaW9uIDhpIGVudGVycHJpc2Ug ZWRpdGlvbi48L0ZPTlQ+DQo8L1A+DQoNCjxQPjxGT05UIFNJWkU9MiBGQUNFPSJBcmlhbCI+TXkg cmVwbHkgd2FzIHRoYXQgaXQgd2FzIGEgdmVyeSByb3VnaCBlc3RpbWF0ZSwgYnV0IEkgd291bGQg dGhpbmsgdGhhdCA1MDBNIHdhcyBzdWZmaWNpZW50IGZvciB0aGUgbWFjaGluZSBhbmQgdGhhdCBP cmFjbGUgd291bGQgdGFrZSB1cCAzMDBNIGluIHRoZSBTR0Egb3Igc28uJm5ic3A7IDwvRk9OVD48 L1A+DQoNCjxQPjxGT05UIFNJWkU9MiBGQUNFPSJBcmlhbCI+SSBnZXQgYSByZXBseSB0aGF0IHRo ZWlyIERCQSBzYWlkIGF0IGxlYXN0IDEuNSBnIG1lbW9yeSBvciBtb3JlLiZuYnNwOyBOb3cgSSBo YXZlIDQgYmFzZXMgb24gb25lIEhQLXV4IHNlcnZlciB0aGF0IHRvdGFsIDIwKyBnaWcgc3BhY2Ug YW5kIG92ZXIgMTAwIHVzZXJzIGFuZCB0aGUgTWFjaGluZSBoYXMgNzUwTSB0b3RhbCBtZW1vcnkg Zm9yIGJhc2VzLCBwcm9jZXNzZXMgYW5kIGFsbC4mbmJzcDsgVGhleSBydW4ganVzdCBmaW5lLiZu YnNwOyBGYXN0IHJlc3BvbnNlIGFuZCBhbGwuPC9GT05UPjwvUD4NCg0KPFA+PEZPTlQgU0laRT0y IEZBQ0U9IkFyaWFsIj5BbSBJIGp1c3Qgb3V0IGluIGxlZnQgZmllbGQgaGVyZT8mbmJzcDsgSSBr bm93IGl0IGlzbid0IGVhc3kgc2l6aW5nIGEgc2VydmVyIHdpdGggYmFzaWNhbGx5IG5vIGluZm9y bWF0aW9uIGJ5IHBob25lLCBidXQgSSB0aG91Z2h0IChnaXZlbiB0aGUgcGFyYW1ldGVycykgdGhh dCA1MDBNIHdhcyBhIGRlY2VudCBlc3RpbWF0ZS4mbmJzcDsgQW55b25lPzwvRk9OVD48L1A+DQoN CjxQPjxGT05UIFNJWkU9MiBGQUNFPSJBcmlhbCI+LS1DaHJpczwvRk9OVD4NCjxCUj48Rk9OVCBT SVpFPTIgRkFDRT0iQXJpYWwiPkNocmlzLkJvd2VzQEtvc2EuY29tPC9GT05UPg0KPC9QPg0KDQo8 Received on Tue Aug 01 2000 - 11:44:06 CDT