Some of the threads in weblogic are taking long time to process or blocking the other threads to complete their operation.
Can anyone analyze on the following threads and let me know where we are stuck.
I believe there is some activity at database level is the cause for the issue.
weblogic server 8.1.5
OS :windows 2003
"Thread-13" prio=5 tid=0x03bd3298 nid=0x1794 waiting for monitor entry [59af000..59afd90] ���� at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:1028) ���� - waiting to lock <0x193baf38> (a oracle.jdbc.driver.T4CConnection) at oracle.jdbc.OracleConnectionWrapper.rollback(OracleConnectionWrapper.java:91) ���� at weblogic.jdbc.wrapper.XAConnection.rollback(XAConnection.java:792) ���� at weblogic.jdbc.wrapper.Connection.forcedCleanup(Connection.java:130) ���� at weblogic.common.resourcepool.ResourcePoolImpl.timeoutInactiveResources(ResourcePoolImpl.java:1877) ���� at weblogic.common.resourcepool.ResourcePoolImpl.access$400(ResourcePoolImpl.java:27) ���� at weblogic.common.resourcepool.ResourcePoolImpl$ResourcePoolMaintanenceTask.run(ResourcePoolImpl.java:2143) ���� at java.util.TimerThread.mainLoop(Timer.java:432) ���� at java.util.TimerThread.run(Timer.java:382)
__________________________________________________________________
Thread dump 1/7 "ExecuteThread: '4' for queue: 'weblogic.kernel.System'" daemon prio=5 tid=0x03daca80 nid=0x14c0 waiting for monitor entry [4e5f000..4e5fd90] ���� at oracle.jdbc.driver.OraclePreparedStatement.clearParameters(OraclePreparedStatement.java:8417) ���� - waiting to lock <0x199675d8> (a oracle.jdbc.driver.T4CPreparedStatement) at weblogic.jdbc.common.internal.ConnectionEnv.cleanUpStatementForReUse(ConnectionEnv.java:1262) at weblogic.jdbc.common.internal.ConnectionEnv.returnCachedStatement(ConnectionEnv.java:1047) ���� - locked <
0x1984ba00> (a java.lang.Object) ���� at weblogic.jdbc.wrapper.Statement.internalClose(Statement.java:326) ���� at weblogic.jdbc.wrapper.Connection.closeAllStatements(Connection.java:275) ���� at weblogic.jdbc.wrapper.JTAConnection.closeAllStatements(JTAConnection.java:169) ���� at weblogic.jdbc.wrapper.JTAConnection.releaseXAConnIfNeeded(JTAConnection.java:241) ���� - locked <
0x19967368> (a weblogic.jdbc.wrapper.JTAConnection_weblogic_jdbc_wrapper_XAConnection_oracle_jdbc_driver_LogicalConnection) ���� at weblogic.jdbc.wrapper.JTAConnection.doClose(JTAConnection.java:531) ���� at weblogic.jdbc.wrapper.JTAConnection.close(JTAConnection.java:391) ���� at weblogic.jdbc.rmi.internal.ConnectionImpl.close(ConnectionImpl.java:270) ���� at weblogic.jdbc.rmi.internal.ConnectionImpl.peerGone(ConnectionImpl.java:137) ���� at weblogic.rjvm.RJVMImpl$PeerGoneDeliverer.execute(RJVMImpl.java:1628) ���� at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:224) ���� at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:183)
___________________________________________________________________
Thread dump 1/7 "ExecuteThread: '16' for queue: 'weblogic.kernel.Default'" daemon prio=5 tid=0x03d9abd8 nid=0x1b9c runnable [4a1f000..4a1fd90] ���� at java.net.SocketInputStream.socketRead0(Native Method) ���� at java.net.SocketInputStream.read(SocketInputStream.java:129) ���� at oracle.net.ns.Packet.receive(Unknown Source) ���� at oracle.net.ns.DataPacket.receive(Unknown Source) ���� at oracle.net.ns.NetInputStream.getNextPacket(Unknown Source) ���� at oracle.net.ns.NetInputStream.read(Unknown Source) ���� at oracle.net.ns.NetInputStream.read(Unknown Source) ���� at oracle.net.ns.NetInputStream.read(Unknown Source) ���� at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:979) ���� at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:951) ���� at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:435) ���� at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:182) ���� at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:630) ���� at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1081) ���� at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2905) ���� at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:2996) ���� - locked <
0x197b32d8> (a oracle.jdbc.driver.T4CPreparedStatement) ���� - locked <
0x193baf38> (a oracle.jdbc.driver.T4CConnection) ���� at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:102) ���� at weblogic.jdbc.rmi.internal.PreparedStatementImpl_weblogic_jdbc_wrapper_PreparedStatement_oracle_jdbc_driver_T4CPreparedStatement.execute(Unknown Source) ���� at weblogic.jdbc.rmi.internal.PreparedStatementImpl_weblogic_jdbc_wrapper_PreparedStatement_oracle_jdbc_driver_T4CPreparedStatement_WLSkel.invoke(Unknown Source) ���� at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:492) ���� at weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:435) ���� at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363) ���� at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:147) ���� at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:430) ���� at weblogic.rmi.internal.BasicExecuteRequest.execute(BasicExecuteRequest.java:35) ���� at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:224) ���� at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:183)