WebLogic Thread Hangs In Writing Object Greater Than 2M Into CLOB Column

(Doc ID 1614109.1)

Last updated on AUGUST 16, 2016

Applies to:

JDBC - Version 11.2.0.1 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

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