Poor Performance When Using CLOBS and Oracle Net
(Doc ID 398380.1)
Last updated on FEBRUARY 27, 2019
Applies to:Oracle Net Services - Version 126.96.36.199 and later
Oracle Database - Enterprise Edition - Version 188.8.131.52 and later
Information in this document applies to any platform.
Oracle Server - Enterprise Edition - Version: 9.2 to 10.2
This problem can occur on any platform.
CLOBS Oracle Net
Performance of CLOBS can be poor/slow when using Oracle Net.
Typically a Oracle Net client trace will show a delay in the timestamp, reported in two areas.
These delays are repeated often, slowing down response time. Changing SDU or arraysize will not assist here.
Database stats pack report can report high value for "SQL*Net message from Client"
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