Excessive RAM and Swap utilization
661798Mar 31 2009 — edited Mar 31 2009Hi All ,
We have a Test environment where Physical RAM and Swap space utilization goes pretty high. Smtime No db connection possible as ther isnt enugh
space in RAM /Swap to accomadate new process.
ORA-27300: BS-abhängiger Vorgang fork mit Status: 12 nicht erfolgreich
ORA-27301: BS-Fehlermeldung: Not enough space
ORA-27302: Fehler aufgetreten bei: skgpspawn3
RAM= 6GB , Swap = 4GB , OS: AIX 5L 64 bit
since the DB size is pretty small 30GB and max user session goes upto 350 . i dont understand what consume so much of RAM and Swap space.
Physical PageSpace
│% Used 98.1% 59.2%
│% Free 1.9% 40.8%
│MB Used 6025.5MB 2426.8MB
│MB Free 118.5MB 1669.2MB
│Total(MB) 6144.0MB 4096.0MB
oracle@cob1a025:/home/oracle> vmstat 1 10
System configuration: lcpu=8 mem=6144MB ent=2.00
kthr memory page faults cpu
----- ----------- ------------------------ ------------ -----------------------
r b avm fre re pi po fr sr cy in sy cs us sy id wa pc ec
1 2 1693533 38276 0 55 0 0 0 0 2199 3497 11007 22 14 53 11 0.86 42.8
3 2 1693530 34797 0 29 0 0 0 0 2370 5409 13933 17 14 62 7 0.72 36.1
0 6 1693564 29899 0 17 0 0 0 0 3218 2523 17845 31 12 53 4 0.92 46.0
2 2 1693868 25483 0 18 0 0 0 0 2564 2028 16478 45 12 34 10 1.24 61.9
1 2 1694447 21099 0 29 0 0 0 0 2381 12471 13311 57 14 24 5 1.55 77.5
any sugesstion would be highly appricited. Thanks