My Oracle Support Banner

Increase of Threads When A SQL Statement Execution Takes For A Long Time (Doc ID 1912569.1)

Last updated on FEBRUARY 03, 2019

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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.