My Oracle Support Banner

WebLogic Thread Hangs In Writing Object Greater Than 2M Into CLOB Column (Doc ID 1614109.1)

Last updated on NOVEMBER 05, 2021

Applies to:

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


Using Oracle database and JDBC driver, WebLogic 12c threads take extensive time in writing object of size exceeding 2Mb, into a CLOB column on Oracle 11g database.
When size is 1.9Mb, loading data within table only takes a few seconds.

From nohup WebLogic logs, the following is observed:


Data packet of 8k had taken inconsistently high interval to reach the database server.

At the database side, many waits for 'SQL*Net more data to client' events  are reported. The database is actually waiting for the client.


 WebLogic was upgraded from 8.1 to 12c, and Oracle database was upgraded from 10g to 11g.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.