WebLogic Thread Hangs In Writing Object Greater Than 2M Into CLOB Column
(Doc ID 1614109.1)
Last updated on AUGUST 09, 2023
Applies to:
JDBC - Version 11.2.0.1.0 and laterOracle 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 |