WebLogic Thread Hangs In Writing Object Greater Than 2M Into CLOB Column
Last updated on AUGUST 16, 2016
Applies to:JDBC - Version 22.214.171.124 and later
Oracle WebLogic Server - Version 126.96.36.199 and later
Information in this document applies to any platform.
Using Oracle database 188.8.131.52 and JDBC driver 184.108.40.206, 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.
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