Originally posted by nagarjuna
check your hit ratio and try to reduce the db buffer cache.

How did you find the memory usage of each oracle process? Using top? Top mis guides..
I check the RSS(Resident Set Size) on glance for each process. It is suppose to give the total memory usage for each process. My Free Memory is going down to less than 60 meg during the peak hour(ususaly during 2:00pm - 3:00pm). I kill some of the most memory consuming porcesses to free up the memory. ANy advice on how to resolve the issue and not just ask for more memory. The DB buffer Cache was increased gradually to imporve performance. I guess I p'bly can decrese to some extent but not a whole lot.

The other thing is any connection from siebel evenif not active on oracle still uses the memory on the Box.