tomcat老是出现类似问题,该怎么解决?

[feixzmm]

情况大概是这样的:
主机是linux,tomcat,版本是4.0.6,数据库是oracle,
总体数据量较大,不知道为什么,服务器运行几天或一周左右,
页面上的功能菜单的显示就会很慢,等半天都看不到菜单(这些菜单
是从数据库表里取出来的),
浏览器进度条也死在一半左右,没办法就好重启tomcat,重启完
一般就好了,而且比较奇怪的是,重启的时候,每次我先执行./shutdown.sh后,
ps -ef|grep tomcat,发现还有很多进程跑,只好kill -9 pid,然后再
执行./startup.sh.
情况大概就这么回事,请各位熟悉此类情况的兄弟们支支招吧,谢谢了!

[feixzmm]

这是localhost日志,请帮忙分析一下
2006-02-09 00:02:37 StandardWrapperValve[default]: Servlet.service() for servlet default threw excep
tion
java.net.SocketException: Connection reset
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:96)
at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
at org.apache.catalina.connector.ResponseBase.flushBuffer(ResponseBase.java:674)
at org.apache.catalina.connector.HttpResponseBase.flushBuffer(HttpResponseBase.java:764)
at org.apache.catalina.connector.ResponseBase.write(ResponseBase.java:647)
at org.apache.catalina.connector.ResponseStream.write(ResponseStream.java:312)
at org.apache.catalina.connector.http.HttpResponseStream.write(HttpResponseStream.java:189)
at org.apache.catalina.servlets.DefaultServlet.copyRange(DefaultServlet.java:1921)
at org.apache.catalina.servlets.DefaultServlet.copy(DefaultServlet.java:1670)
at org.apache.catalina.servlets.DefaultServlet.serveResource(DefaultServlet.java:1215)
at org.apache.catalina.servlets.DefaultServlet.doGet(DefaultServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.j
ava:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1027)
at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1125)
at java.lang.Thread.run(Thread.java:534)

[baggio785]

程序中oracle的资源释放了么？

[skycncomp]

招聘
地点北京

qq: 283765999

[yangl8284]

以前用ASP做政务系统的时候也遇到过这个情况，数据量过大，造成IIS挂了，后来从SQL语句入手，优化程序及SQL语句，还有能用Index最好，View也行，你再试试吧

[zeq258]

一般进程在跑，主要是数据库连接这部分的问题，