机器是这样的,rhel4 u4 + oracle 10.2.0.4 32bit,用了lvm将SGA扩到4G,PGA 800M
上周内存是8G,用top看,都已基本耗光,本周又加了8G上去,用top看发现16G的空间又用完了,请帮忙看看.
top - 21:52:33 up 2 days, 9:00, 2 users, load average: 0.02, 0.05, 0.00
Tasks: 131 total, 1 running, 130 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.2% us, 0.3% sy, 0.0% ni, 99.2% id, 0.3% wa, 0.0% hi, 0.0% si
Mem: 16631432k total, 16615208k used, 16224k free, 13628k buffers
Swap: 10482404k total, 119480k used, 10362924k free, 16186668k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
16414 oracle 19 0 1666m 534m 531m S 3 3.3 0:00.09 oracle
16369 oracle 16 0 1665m 602m 599m S 1 3.7 0:05.77 oracle
16225 oracle 15 0 1665m 542m 539m S 0 3.3 0:00.68 oracle
4946 oracle 16 0 1665m 527m 524m S 0 3.2 0:00.77 oracle
4948 oracle 15 0 1664m 524m 521m S 0 3.2 0:00.45 oracle
4950 oracle 16 0 1664m 524m 521m S 0 3.2 0:00.27 oracle
4952 oracle 16 0 1668m 612m 607m S 0 3.8 0:04.79 oracle
4954 oracle 15 0 1679m 540m 537m S 0 3.3 0:02.21 oracle
4956 oracle 16 0 1665m 589m 587m S 0 3.6 0:07.19 oracle
4958 oracle 16 0 1666m 595m 592m S 0 3.7 0:03.39 oracle
4960 oracle 16 0 1664m 531m 529m S 0 3.3 0:00.29 oracle
4962 oracle 15 0 1669m 554m 549m S 0 3.4 0:09.26 oracle
4964 oracle 16 0 1667m 564m 559m S 0 3.5 0:01.58 oracle
4966 oracle 16 0 1664m 541m 539m S 0 3.3 0:02.12 oracle
4968 oracle 16 0 1665m 524m 521m S 0 3.2 0:00.29 oracle
4970 oracle 16 0 1664m 523m 521m S 0 3.2 0:00.27 oracle
4975 oracle 17 0 1664m 525m 522m S 0 3.2 0:00.28 oracle
4987 oracle 16 0 1664m 528m 525m S 0 3.3 0:00.29 oracle
4989 oracle 16 0 1664m 524m 522m S 0 3.2 0:00.30 oracle
4996 oracle 15 0 21764 5688 4176 S 0 0.0 0:00.71 tnslsnr
5021 oracle 16 0 1665m 537m 535m S 0 3.3 289:59.82 oracle
5025 oracle 16 0 1665m 537m 534m S 0 3.3 109:59.65 oracle
5029 oracle 16 0 1665m 537m 534m S 0 3.3 0:00.35 oracle
5031 oracle 16 0 1775m 694m 652m S 0 4.3 7:24.96 oracle
15996 oracle 16 0 1665m 537m 534m S 0 3.3 0:00.68 oracle
15998 oracle 16 0 1665m 551m 548m S 0 3.4 0:08.04 oracle
16134 oracle 15 0 1668m 628m 624m S 0 3.9 0:47.61 oracle
16233 oracle 15 0 1665m 644m 640m S 0 4.0 0:25.53 oracle
16235 oracle 15 0 1666m 645m 641m S 0 4.0 0:27.02 oracle
16252 oracle 16 0 1665m 542m 538m S 0 3.3 0:00.81 oracle
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/271283/viewspace-417719/,如需转载,请注明出处,否则将追究法律责任。