Hello,

The oracle processes on my system had taken up all the available memory.

Is this an oracle bug or are there some oracle prameters for tuning memory use ?

Many thanks

john


02:21:42 up 38 days, 6:05, 6 users, load average: 2.02, 2.13, 2.18
489 processes: 486 sleeping, 2 running, 1 zombie, 0 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 25.4% 0.0% 0.7% 0.0% 0.0% 0.4% 73.2%
cpu00 52.0% 0.0% 0.0% 0.0% 0.0% 1.5% 46.3%
cpu01 45.4% 0.0% 0.5% 0.0% 0.0% 0.1% 53.7%
cpu02 1.9% 0.0% 1.5% 0.0% 0.1% 0.0% 96.2%
cpu03 2.3% 0.0% 0.7% 0.0% 0.0% 0.0% 96.8%
Mem: 5064168k av, 5035284k used, 28884k free, 0k shrd, 11220k buff
3392408k actv, 796324k in_d, 113292k in_c
Swap: 4096312k av, 292k used, 4096020k free 3137232k cached

PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
4864 oracle 15 0 1088M 1.1G 1083M S 0.0 21.9 16:28 0 oracle
4858 oracle 15 0 1069M 1.0G 1057M S 0.0 21.5 66:30 3 oracle
4860 oracle 15 0 1063M 1.0G 1051M S 0.0 21.3 64:23 2 oracle
4969 oracle 15 0 1020M 1.0G 988M S 0.0 20.5 17:03 1 oracle
4874 oracle 15 0 709M 708M 705M S 0.0 14.3 24:21 0 oracle
4870 oracle 15 0 677M 664M 651M S 0.0 13.4 3:56 0 oracle
9944 oracle 15 0 255M 254M 252M S 0.0 5.1 45:53 2 oracle
13485 oracle 15 0 198M 196M 193M S 0.0 3.9 0:14 0 oracle
4892 oracle 15 0 196M 195M 193M S 0.0 3.9 5:28 0