Oracle Eats RAM, none left for Gods

We had 100% RAM filled ( constantly 50-100M in swap ) and horrid performance with Oracle8 and Solaris2.6 with 3G of RAM.

We added a GIG of RAM.

We STILL have 50-100M in swap.

What configuration setting is allowing Oracle to consume all available memory? OR, since we aren't running anything else on the machine, is using all memory this way better than limiting what this greedy monster consumes.

Performace is better with the new RAM, but I still think Oracle's behaviour is wrong. We used to page out under heavy stress. We haven't seen loads like before yet (we saw mid 20s) and no one has complained yet withg the new RAM HOWEVER an answer exists.

Thank you in advance for any assistance in providing it,

--

Joshua Simeon Narins, President, NCCPC
UNIX/RDBMS Development
When you need it yesterday.

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