帮忙看看是什么把内存吃光了
环境是linuxAS4, oracle9i
[root@Hnepc_EAMDB /]# ps -aux
Warning: bad syntax, perhaps a bogus '- '? See /usr/share/doc/procps-3.2.3/FAQ
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
root 1 0.0 0.0 2716 528 ? S 2006 6:27 init [3]
root 2 0.0 0.0 0 0 ? S 2006 0:02 [migration/0]
root 3 0.0 0.0 0 0 ? SN 2006 0:00 [ksoftirqd/0]
root 4 0.0 0.0 0 0 ? S 2006 0:07 [migration/1]
root 5 0.0 0.0 0 0 ? SN 2006 0:00 [ksoftirqd/1]
root 6 0.0 0.0 0 0 ? S 2006 0:02 [migration/2]
root 7 0.0 0.0 0 0 ? SN 2006 0:00 [ksoftirqd/2]
root 8 0.0 0.0 0 0 ? S 2006 0:01 [migration/3]
root 9 0.0 0.0 0 0 ? SN 2006 0:00 [ksoftirqd/3]
root 10 0.0 0.0 0 0 ? S 2006 0:01 [migration/4]
root 11 0.0 0.0 0 0 ? SN 2006 0:00 [ksoftirqd/4]
root 12 0.0 0.0 0 0 ? S 2006 0:01 [migration/5]
root 13 0.0 0.0 0 0 ? SN 2006 0:00 [ksoftirqd/5]
root 14 0.0 0.0 0 0 ? S 2006 0:01 [migration/6]
root 15 0.0 0.0 0 0 ? SN 2006 0:00 [ksoftirqd/6]
root 16 0.0 0.0 0 0 ? S 2006 0:01 [migration/7]
root 17 0.0 0.0 0 0 ? SN 2006 0:00 [ksoftirqd/7]
root 18 0.0 0.0 0 0 ? S < 2006 0:00 [events/0]
root 19 0.0 0.0 0 0 ? S < 2006 0:00 [events/1]
root 20 0.0 0.0 0 0 ? S < 2006 0:00 [events/2]
root 21 0.0 0.0 0 0 ? S < 2006 0:00 [events/3]
root 22 0.0 0.0 0 0 ? S < 2006 0:00 [events/4]
root 23 0.0 0.0 0 0 ? S < 2006 0:00 [events/5]
root 24 0.0 0.0 0 0 ? S < 2006 0:00 [events/6]
root 25 0.0 0.0 0 0 ? S < 2006 0:00 [events/7]
root 26 0.0 0.0 0 0 ? S < 2006 0:00 [khelper]
root 27 0.0 0.0 0 0 ? S < 2006 0:00 [kacpid]
root 129 0.0 0.0 0 0 ? S < 2006 0:00 [kblockd/0]
root 130 0.0 0.0 0 0 ? S < 2006 0:00 [kblockd/1]
root 131 0.0 0.0 0 0 ? S < 2006 0:00 [kblockd/2]
root 132 0.0 0.0 0 0 ? S < 2006 0:00 [kblockd/3]
root 133 0.0 0.0 0 0 ? S < 2006 0:00 [kblockd/4]
root 134 0.0 0.0 0 0 ? S < 2006 0:00 [kblockd/5]
root 135 0.0 0.0 0 0 ? S < 2006 0:00 [kblockd/6]
root 136 0.0 0.0 0 0 ? S < 2006 0:00 [kblockd/7]
root 137 0.0 0.0 0 0 ? S 2006 0:00 [khubd]
root 157 0.0 0.0 0 0 ? S < 2006 0:00 [aio/0]
root 158 0.0 0.0 0 0 ?
root 24486 0.0 0.0 10764 4148 ? Ss 14:26 0:00 pam-panel-icon --
root 24488 0.6 0.2 33028 21668 ? SNs 14:26 0:05 /usr/bin/python /
root 24491 0.0 0.0 2408 620 ? S 14:26 0:00 /sbin/pam_timesta
root 24494 0.0 0.0 19396 3536 ? Sl 14:26 0:00 /usr/libexec/gnom
root 24507 0.0 0.0 3212 740 ? S 14:26 0:00 /usr/libexec/mapp
root 24509 0.0 0.1 22992 11696 ? S 14:26 0:00 /usr/libexec/wnck
root 24511 0.0 0.1 17708 8364 ? S 14:26 0:00 /usr/libexec/gnom
root 24513 0.0 0.1 19440 9328 ? S 14:26 0:00 /usr/libexec/mixe
root 24515 0.0 0.1 21664 9288 ? S 14:26 0:00 /usr/libexec/cloc
root 24517 0.0 0.0 17784 6908 ? S 14:26 0:00 /usr/libexec/noti
root 24519 0.0 0.1 19748 9456 ? S 14:26 0:00 /usr/libexec/gnom
root 24521 0.2 0.1 38144 13440 ? Rl 14:26 0:01 gnome-terminal
root 24523 0.0 0.0 2824 636 ? S 14:26 0:00 gnome-pty-helper
root 24524 0.0 0.0 7340 1480 pts/0 Ss 14:26 0:00 bash
oracle 24549 0.0 1.2 1713840 103324 ? S 14:27 0:00 oracleeamdb (LOCA
oracle 24553 0.0 1.0 1713840 83368 ? S 14:28 0:00 oracleeamdb (LOCA
root 24613 0.0 0.0 2208 532 pts/1 S+ 14:37 0:00 sleep 300
oracle 24617 6.9 6.5 1714844 545800 ? S 14:37 0:09 oracleeamdb (LOCA
oracle 24626 29.5 4.1 1716360 344308 ? S 14:38 0:18 oracleeamdb (LOCA
root 24628 0.0 0.0 3724 804 pts/0 R+ 14:39 0:00 ps -aux
oracle 22492 0.0 0.1 1713880 8620 ? Ss Feb07 0:01 ora_pmon_eamdb
oracle 22494 0.0 4.7 1714276 398056 ? Ds Feb07 0:08 ora_dbw0_eamdb
oracle 22496 0.0 0.5 1721704 42868 ? Ss Feb07 0:19 ora_lgwr_eamdb
oracle 22498 0.0 0.3 1716608 31604 ? Ss Feb07 0:07 ora_ckpt_eamdb
oracle 22500 0.0 7.6 1714920 632260 ? Ss Feb07 0:11 ora_smon_eamdb
oracle 22502 0.0 0.3 1713184 28468 ? Ss Feb07 0:00 ora_reco_eamdb
oracle 22504 0.0 0.1 1713188 15756 ? Ss Feb07 0:00 ora_cjq0_eamdb
oracle 22506 0.0 2.4 1713852 206544 ? Ss Feb07 0:19 ora_qmn0_eamdb
oracle 22508 0.0 2.4 1713928 200248 ? Ss Feb07 0:19 ora_qmn1_eamdb
oracle 22510 0.0 2.4 1713928 203280 ? Ss Feb07 0:19 ora_qmn2_eamdb
oracle 22512 0.0 2.4 1713928 199776 ? Ss Feb07 0:19 ora_qmn3_eamdb
oracle 22514 0.0 2.4 1713928 200640 ? Ss Feb07 0:19 ora_qmn4_eamdb
oracle 24060 6.0 13.9 1718372 1155872 ? S 10:33 14:57 oracleeamdb (LOCA
oracle 24063 0.0 1.6 1714000 134380 ? S 10:34 0:02 oracleeamdb (LOCA
oracle 24065 0.0 1.7 1714016 141336 ? S 10:34 0:02 oracleeamdb (LOCA
oracle 24128 0.0 0.7 1713884 62760 ? S 11:45 0:01 oracleeamdb (LOCA
oracle 24193 3.3 10.4 1715252 868460 ? S 12:38 4:06 oracleeamdb (LOCA
oracle 24258 4.0 10.9 1716860 905784 ? S 13:33 2:38 oracleeamdb (LOCA
[解决办法]
我也见过这种情况,并且我在几台机器上测试过,在刚启动oracle的时候,内存剩下一半,
一段时间以后,即使oracle的用户会话进程终止,linux系统好象也不会释放内存一样,用top,free或类似的工具查看内存,会看到剩下的内存没有多少了,不知道是不是linux系统的原因
[解决办法]
还有
24547 oracle 15 0 1676m 461m 457m S 26 5.7 0:45.51 oracle
24193 oracle 16 0 1676m 821m 817m S 2 10.1 3:53.42 oracle
这两个进程在干什么.是什么进程.
[解决办法]
关注
[解决办法]
关注
[解决办法]
数据库系统内存占用到7,80%是正常的,我用AIX,IBM的人说内存100%也可以是正常的,关系到他内存释放机制,只要swap 没怎么被用就证明内存一直够的。