oracle process use memory quesiton
they set sga=2.1G, pga=400M, so all add is 2.5G,
in the rush hour ,there is 100 process .
we see a lot page in and page out happen!
[URP-DB1][/]#vmstat 1 1000
System configuration: lcpu=4 mem=3920MB
kthr memory page faults cpu
----- ----------- ------------------------ ------------ -----------
r b avm fre re pi po fr sr cy in sy cs us sy id wa
3 0 995871 5197 0 4 0 0 0 0 2083 22676 17987 53 7 26 14
0 0 995863 5205 0 0 0 0 0 0 2399 19946 10346 46 4 34 16
0 0 998186 2834 0 1 0 0 0 0 2055 17778 9274 48 4 33 15
0 0 995914 5120 0 6 0 9 29 0 2335 19190 10100 51 5 29 15
0 0 995999 5179 0 6 1 17 1539 1 2567 24872 12152 53 6 25 15
0 0 998122 2928 0 11 1 9 49 0 2223 25817 20090 52 8 25 15
2 0 998630 2420 0 0 0 0 0 0 2644 25561 11787 58 5 25 12
1 0 998033 3001 0 1 0 0 0 0 2120 17669 9019 54 4 28 14
2 0 996109 4924 0 0 0 0 0 0 2620 22437 11805 57 5 27 12
6 0 998513 2472 0 10 1 26 542 0 1896 15537 7311 50 3 32 15
2 0 998651 2398 0 4 2 9 271 0 2491 28116 19524 50 8 28 14
4 0 996115 4918 0 1 0 0 0 0 2211 18084 9698 48 4 32 16
0 0 996115 4886 0 2 0 0 0 0 2466 20087 10470 54 4 27 14
0 0 996162 4838 0 0 0 0 0 0 2332 21450 10481 52 5 26 16
0 0 996278 4962 0 2 6 17 1661 1 2418 21196 10857 56 5 23 17
2 0 996244 4996 0 0 0 0 0 0 2161 23056 18222 42 7 36 15
our os admin use svmon -Pv -t 10|pg to check process memory;
[URP-DB1][/]#ps -ef|grep 692454
oracle 692454 1 1 22:25:24 - 14:11 oracleusdpdb (LOCAL=NO)
*****
[URP-DB1][/]#ps -ef|grep 1343650