手上有一台P6的机器,安装应用和oracle以后使用正常,但现在的问题是每天内存的使用率都会比前一天高出1-2%,这样的话1个月左右内存会耗尽。
请参考附件贴图。
根据PID 号查到
[url=]shfp@/#ps[/url] -ef | grep 475368
shora10 475368 1 0 Aug 22 - 0:08 ora_lgwr_SHTEST
[url=]shfp@/#ps[/url] -ef | grep 315558
shfp10 315558 1 0 Aug 22 - 0:11 ora_lgwr_SHFP
[url=]shfp@/#ps[/url] -ef | grep 270502
shora10 270502 1 0 Aug 22 - 0:57 ora_cjq0_SHTEST
[url=]shfp@/#ps[/url] -ef | grep 454882
shora10 454882 1 0 Aug 22 - 1:27 ora_pmon_SHTEST
[url=]shfp@/#ps[/url] -ef | grep 467172
shora10 467172 1 0 Aug 22 - 0:11 ora_dbw0_SHTEST
[url=]shfp@/#ps[/url] -ef | grep 491760
shora10 491760 1 0 Aug 22 - 1:44 ora_mmon_SHTEST
[url=]shfp@/#ps[/url] -ef | grep 471270
shora10 471270 1 0 Aug 22 - 0:11 ora_dbw1_SHTEST
[url=]shfp@/#ps[/url] -ef | grep 479466
shora10 479466 1 0 Aug 22 - 2:41 ora_ckpt_SHTEST
[url=]shfp@/#ps[/url] -ef | grep 483564
shora10 483564 1 0 Aug 22 - 0:15 ora_smon_SHTEST
[url=]shfp@/#ps[/url] -ef | grep 409802
shfp10 409802 1 0 Aug 22 - 0:57 ora_cjq0_SHFP
[url=]shfp@/#ps[/url] -ef | grep 487662
shora10 487662 1 0 Aug 22 - 0:00 ora_reco_SHTEST
.........
耗内存资源的都是oracle的一些进程,请提供优化建议。
收起