最近接手了一个项目,关于性能优化的,客户是电力行业的,目前主要是用户反应操作响应时间很慢,主机是IBM P570,aix5.3的系统,安装oracle 10g数据库以及weblogic9.2.2,通过对主机cpu、内存、I/O的分析,发现主机并不存在太大的性能缺陷,现问题主要是分析数据库和中间件,但是收集的一些数据我自己都看不是太懂,所以想咨询下各位高人,中间件现在存在怎么样的问题,怎样调整能消除报错信息?在此先谢谢各位了!
####<2013-6-12 下午01时49分13秒 GMT+08:00>
<[ACTIVE] ExecuteThread: '52' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <> <1371016153167>
####<2013-6-12 下午01时49分23秒 GMT+08:00> <[ACTIVE] ExecuteThread: '52' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <> <1371016163168> <[weblogic.servlet.internal.WebAppServletContext@72cf72cf - appName: 'j2yd', name: 'j2yd.war', context-path: '/j2yd'] Root cause of ServletException.
highsoft.common.exception.DBException: 执行数据库查询出错!查询语句:select right_item_name,right_class_code from right_item where right_item_code = ? ,查询参数:[806095]
####<2013-6-12 下午01时51分12秒 GMT+08:00> <[ACTIVE] ExecuteThread: '99' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <> <1371016272815> <[STUCK] ExecuteThread: '42' for queue: 'weblogic.kernel.Default (self-tuning)' has been busy for "659" seconds working on the request "Http Request: /j2yd/login.do", which is more than the configured time (StuckThreadMaxTime) of "600" seconds. Stack trace:
####<2013-6-12 下午01时52分15秒 GMT+08:00> <[STUCK] ExecuteThread: '227' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <> <1371016335110> <[STUCK] ExecuteThread: '227' for queue: 'weblogic.kernel.Default (self-tuning)' has become "unstuck".>收起