Re: Oracle Eats RAM, none left for Gods

From: JoshNarins <joshnarins_at_my-dejanews.com>
Date: Mon, 26 Apr 1999 21:33:11 GMT
Message-ID: <7g2m2n$6d8$1@nnrp1.dejanews.com>

I come from a UNIX SA background on Digital, HP-UX, SCO and some older SunOS and Solaris. I had never heard of normal swap in use. There is no swapping going on, but before we added the RAM there was occasionally a lot of paging. The short term expected memory shortfall also was high a lot.

So, already, you have answered my question in stating that SOME SWAP is ok.

> How big is your SGA? Each of the components of the SGA?
> What else do you do on the machine?
> How many connected users do you typically have? What are they typically
doing?

SGA is 1.3Gig. I wouldn't know about the components, sorry. I'm not even the DBA, it is just a very important system and they spend time doing things I did not recognize as useful, meanwhile, memory usage was atrocious. We do NOTHING else on the machine. Except monitor it. Connected users ~140-200. Typically doing routine queries.

No response is necessary, thank you for your time.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Apr 26 1999 - 16:33:11 CDT