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 11.2.0.1.0 and later
Oracle WebLogic Server - Version 12.1.1.0 and later
Information in this document applies to any platform.

Symptoms

Using Oracle database 11.2.0.3 and JDBC driver 11.2.0.3, 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.

Changes

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

Cause

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
Symptoms
Changes
Cause
Solution
References


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