My production database 8.1.7 is running on HPUx 11.11. The total physical memory on the box is 16 Gig. Around the peak time I'm always noticing about less than 100 meg free memory. My SGA is 7.4 Gig(Fixed 100kb, variable 1.0G, DB Buffer=6.4G, Redo=2M). Each process is using up approx 5-7 meg memory. SO during the peak time if there are approx 700 process my total memory usage is about 15G + and so I am left with about 100 meg. I also have 4 swap devices with 4 G each contributing 16G.

My question is ? Is there a way I can redistribute the memory usage or is it inevitable that we need more memory on the box ?? Can anyone give me a way to recalculate the memory usage for oracle and user processes ?