Increase of Threads When A SQL Statement Execution Takes For A Long Time

(Doc ID 1912569.1)

Last updated on APRIL 15, 2018

Applies to:

Oracle WebLogic Server - Version 10.3.6 and later
Information in this document applies to any platform.


Deployed into WLS  server 10.3.6,  an application interacts with Oracle Database  server.
Randomly, a thread (ExecuteThread: '6') executes SQL statement for la long time with the the following thread stack :

[ACTIVE] ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'" - Thread t@44
  java.lang.Thread.State: RUNNABLE
at Method)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(
at oracle.jdbc.driver.OracleStatement.executeUpdate(
- locked (a oracle.jdbc.driver.T4CConnection) at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(
at weblogic.servlet.internal.WebAppServletContext.execute(

When the execution of this SQL statement takes a long time,  there are  threads which are created and blocked with the following thread stack :

"[ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'" - Thread t@41
  java.lang.Thread.State: BLOCKED
at weblogic.transaction.internal.ServerSCInfo.callAfterCompletions(
- waiting to lock (a weblogic.transaction.internal.ServerSCInfo) owned by "[ACTIVE] ExecuteThread: '9' for queue: 'weblogic.kernel.Default (self-tuning)'" t@139
at weblogic.transaction.internal.ServerTransactionImpl.callAfterCompletions(
at weblogic.transaction.internal.ServerTransactionImpl.abandonNow(
at weblogic.transaction.internal.ServerTransactionImpl.access$300(
at weblogic.transaction.internal.ServerTransactionImpl$

The issue is that the number of these threads  (locked on weblogic.transaction.internal.ServerSCInfo handle)  is increasing continuously when  the SQL Statement execution takes a long time. As a consequence,  a restart of WLS server is needed.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms