在9.2.0.4中，数据库才运行了2周，smon与qmn0进程就用各用了420M以上的内存？
ckpt也有100M以上，是不是有问题哦？服务器有4cpu,8G内存，dbwr有两个进程，
共用了500M左右，一直保持不变。
如果这样下去，总会把内存用光的。
[php]
12:10:31up 6 days,9:24,2 users,load average: 1.58, 1.77, 1.76
71 processes: 68 sleeping, 3 running, 0 zombie, 0 stopped
CPU states:cpuusernicesystemirqsoftirqiowaitidle
total9.5%0.0% 11.8% 0.0% 0.0%0.1% 78.4%
cpu00 12.5%0.0% 11.7% 0.0% 0.5%0.0% 75.0%
cpu01 10.7%0.0% 14.7% 0.0% 0.0%0.1% 74.2%
cpu02 13.3%0.0% 17.5% 0.0% 0.0%0.5% 68.4%
cpu036.3%0.0%5.3% 0.0% 0.0%0.1% 88.0%
cpu043.7%0.0%7.7% 0.0% 0.0%0.0% 88.4%
cpu05 17.5%0.0% 17.7% 0.0% 0.0%0.0% 64.6%
cpu067.9%0.0% 13.7% 0.0% 0.0%0.0% 78.2%
cpu073.8%0.0%6.0% 0.0% 0.0%0.0% 90.2%
Mem:8062860k av, 7984520k used, 78340k free, 0k shrd, 59416k buff
4797860k actv,20k in_d,141652k in_c
Swap: 2096440k av,180504k used, 1915936k free
7552920k cached
PID USER PRINISIZERSS SHARE STAT %CPU %MEM TIME CPU COMMAND
12487 oracle25 0 4641244M 43132 R 1.10.5 0:00 5 oracleesal (LOCAL=NO)
12489 oracle25 0 2977228M 27004 R 0.40.3 0:00 4 oracleesal (LOCAL=NO)
1841 oracle25 04552 45162860 S 0.20.054:26 0 /home/oracle/9.2.0.4/bin/tnslsnr LISTENER -inherit
1809 oracle15 0 5507653M 52028 S 0.00.6 1:41 7 ora_pmon_esal
1811 oracle15 0243M 242M239M S 0.03.0 1:26 4 ora_dbw0_esal
1813 oracle15 0247M 246M243M S 0.03.1 1:20 1 ora_dbw1_esal
1815 oracle15 0 11020 97927872 S 0.00.1 3:22 2 ora_lgwr_esal
1817 oracle15 0102M 101M 99.2M S 0.01.2 1:45 4 ora_ckpt_esal
1819 oracle16 0453M 452M449M S 0.05.7 1:28 3 ora_smon_esal
1821 oracle15 0188M 187M186M S 0.02.3 0:00 4 ora_reco_esal
1823 oracle15 0 2797226M 25316 S 0.00.3 0:40 6 ora_cjq0_esal
1825 oracle15 0431M 429M428M S 0.05.4 0:54 4 ora_qmn0_esal
1827 oracle15 0 1465213M6368 S 0.00.1 0:10 0 ora_arc0_esal
1829 oracle15 0 1317611M6360 S 0.00.1 0:12 1 ora_arc1_esal
19833 oracle15 01392 13921156 S 0.00.0 0:00 3 -bash
29261 oracle25 0 1368413M 10920 S 0.00.1 0:00 5 oracleesal (LOCAL=NO)[/php]
|
