redhat as 4.0下的oracle9.2.0.4，发现在点用内存很多，有什么办法降低内存占用

静静的蓝天 2006-07-06 02:40:30

系统redhat as 4.0安装的是oracle 9.2.0.4 for linux.运行的过程中，内存占用越来越多.下面是用ps auxf | grep oracle命令所显示的结果:
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
oracle 3806 0.0 0.1 14304 4384 ? S Jun29 0:38 /u01/app/oracle/product/9.2.0.4/bin/tnslsnr LISTENER -inherit
oracle 3835 0.0 0.2 909568 8988 ? Ss Jun29 0:10 ora_pmon_test
oracle 3837 0.0 1.5 914112 65208 ? Ss Jun29 0:05 ora_dbw0_test
oracle 3839 0.0 0.2 916928 9780 ? Ss Jun29 3:22 ora_lgwr_test
oracle 3841 0.0 0.5 912492 23836 ? Ss Jun29 2:22 ora_ckpt_test
oracle 3843 0.0 1.1 909012 46584 ? Ss Jun29 0:12 ora_smon_test
oracle 3845 0.0 0.3 908852 13584 ? Ss Jun29 0:00 ora_reco_test
oracle 3847 0.0 0.4 908852 17536 ? Ss Jun29 0:38 ora_cjq0_test
oracle 3849 0.0 1.7 909568 72244 ? Ss Jun29 5:32 ora_qmn0_test
oracle 3851 0.0 0.1 909412 7096 ? Ss Jun29 0:00 ora_s000_test
oracle 3853 0.0 0.1 909352 7236 ? Ss Jun29 0:00 ora_d000_test
oracle 3859 1.8 2.7 910744 112660 ? Ss Jun29 193:14 ora_j000_test
oracle 3861 0.6 2.5 909588 105032 ? Ss Jun29 68:09 ora_j001_test
oracle 3863 0.2 2.4 909588 100160 ? Ss Jun29 25:34 ora_j002_test
oracle 3865 0.1 2.3 909588 99252 ? Ss Jun29 16:24 ora_j003_test
oracle 4551 0.0 0.2 909128 10292 ? S Jun29 0:00 oracletest (LOCAL=NO)
oracle 4553 0.0 0.2 909128 9900 ? S Jun29 0:00 oracletest (LOCAL=NO)
oracle 4555 0.0 0.2 909128 10244 ? S Jun29 0:00 oracletest (LOCAL=NO)
oracle 4557 0.0 0.6 909680 25252 ? S Jun29 0:00 oracletest (LOCAL=NO)
oracle 4559 0.0 0.2 909128 9908 ? S Jun29 0:00 oracletest (LOCAL=NO)
oracle 4561 0.0 0.2 909128 9912 ? S Jun29 0:00 oracletest (LOCAL=NO)
oracle 4581 0.0 0.9 909160 38008 ? S Jun29 2:44 oracletest (LOCAL=NO)
oracle 4595 0.0 0.4 909128 19176 ? S Jun29 0:06 oracletest (LOCAL=NO)
oracle 4597 0.0 0.3 909128 13380 ? S Jun29 0:06 oracletest (LOCAL=NO)
oracle 4605 0.0 0.6 909680 25400 ? S Jun29 0:01 oracletest (LOCAL=NO)
oracle 4609 0.0 0.2 909128 10360 ? S Jun29 0:00 oracletest (LOCAL=NO)
oracle 4611 0.0 0.2 909128 10000 ? S Jun29 0:00 oracletest (LOCAL=NO)
oracle 4613 0.0 0.2 909128 10340 ? S Jun29 0:00 oracletest (LOCAL=NO)
oracle 4615 0.0 0.2 909128 10000 ? S Jun29 0:00 oracletest (LOCAL=NO)
oracle 4617 0.0 0.2 909128 10000 ? S Jun29 0:00 oracletest (LOCAL=NO)
oracle 4629 0.0 0.3 909128 15856 ? S Jun29 0:06 oracletest (LOCAL=NO)
oracle 5408 0.0 0.4 909656 19732 ? S Jun29 0:00 oracletest (LOCAL=NO)
oracle 5414 0.0 0.4 909656 20016 ? S Jun29 0:00 oracletest (LOCAL=NO)
oracle 5947 0.0 0.4 909656 16632 ? S Jun29 0:00 oracletest (LOCAL=NO)
oracle 26737 0.0 0.4 909664 17532 ? S Jun30 0:00 oracletest (LOCAL=NO)
oracle 26815 0.0 0.3 909652 15964 ? S Jun30 0:00 oracletest (LOCAL=NO)
oracle 27193 0.0 0.3 909140 13852 ? S Jun30 0:00 oracletest (LOCAL=NO)
oracle 13962 0.0 0.7 909160 29600 ? S Jul01 2:33 oracletest (LOCAL=NO)
oracle 13966 0.0 0.4 909128 16756 ? S Jul01 0:04 oracletest (LOCAL=NO)
oracle 16173 0.0 0.5 910764 24856 ? S 12:14 0:00 oracletest (LOCAL=NO)
oracle 16175 0.0 0.3 909640 14924 ? S 12:14 0:00 oracletest (LOCAL=NO)
oracle 16177 0.0 0.3 909640 14504 ? S 12:14 0:00 oracletest (LOCAL=NO)
oracle 16179 0.0 0.3 910664 16472 ? S 12:14 0:00 oracletest (LOCAL=NO)
oracle 16181 0.0 0.3 909128 13652 ? S 12:14 0:00 oracletest (LOCAL=NO)
oracle 16183 0.0 0.3 910664 14940 ? S 12:14 0:00 oracletest (LOCAL=NO)
oracle 16187 0.0 0.3 910664 15392 ? S 12:14 0:01 oracletest (LOCAL=NO)
oracle 16189 0.0 0.5 910664 21972 ? S 12:14 0:05 oracletest (LOCAL=NO)
oracle 16191 0.0 0.5 910680 23568 ? S 12:14 0:06 oracletest (LOCAL=NO)
oracle 16199 0.0 0.4 909132 17444 ? S 12:15 0:01 oracletest (LOCAL=NO)
oracle 16201 0.0 0.5 909160 22100 ? S 12:15 0:00 oracletest (LOCAL=NO)
oracle 16203 0.0 1.1 909740 45880 ? S 12:15 0:04 oracletest (LOCAL=NO)
oracle 17000 0.0 0.2 909128 10340 ? S 13:24 0:00 oracletest (LOCAL=NO)
oracle 17022 0.0 0.2 909128 11472 ? S 13:26 0:00 oracletest (LOCAL=NO)
oracle 17024 0.0 0.2 909128 11648 ? S 13:26 0:00 oracletest (LOCAL=NO)
oracle 17026 0.0 0.2 909128 11672 ? S 13:26 0:00 oracletest (LOCAL=NO)
oracle 17028 0.0 0.2 909128 11620 ? S 13:26 0:00 oracletest (LOCAL=NO)
oracle 17030 0.0 0.2 909128 10588 ? S 13:26 0:00 oracletest (LOCAL=NO)
oracle 17032 0.0 0.2 909128 11412 ? S 13:26 0:00 oracletest (LOCAL=NO)
oracle 17034 0.0 0.2 909128 11440 ? S 13:26 0:00 oracletest (LOCAL=NO)
oracle 17036 0.0 0.2 909128 11004 ? S 13:26 0:00 oracletest (LOCAL=NO)
oracle 17038 0.0 0.2 909128 11456 ? S 13:26 0:00 oracletest (LOCAL=NO)
oracle 17040 0.0 0.2 909128 11364 ? S 13:26 0:00 oracletest (LOCAL=NO)
oracle 17048 0.0 0.4 909160 18008 ? S 13:27 0:01 oracletest (LOCAL=NO)
oracle 17238 0.0 0.2 909128 10320 ? S 13:44 0:00 oracletest (LOCAL=NO)
oracle 17353 0.0 0.2 909128 10328 ? S 13:54 0:00 oracletest (LOCAL=NO)
oracle 17468 0.0 0.2 909128 10324 ? S 14:04 0:00 oracletest (LOCAL=NO)
oracle 17520 0.0 0.2 909128 10308 ? S 14:09 0:00 oracletest (LOCAL=NO)
oracle 17581 0.0 0.2 909128 10312 ? S 14:14 0:00 oracletest (LOCAL=NO)
oracle 17587 0.0 0.1 908828 6840 ? Ss 14:15 0:00 ora_j004_test
虽说我的应用的连接数有几十个，但是每个连接进程平均占用到16M的内存，是不是正常？
job进程也不断的增长内存.请帮我判断一下，这样的资源占用情况是不是不正常？急，先感谢！

...全文