Poor Performance When Using CLOBS and Oracle Net
Last updated on MAY 22, 2007
Applies to:Oracle Net Services - Version: 9.2 to 10.2
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.
On Basic read
[000001 17-JAN-2006 10:22:40:997] nttrd: entry
[000001 17-JAN-2006 10:22:41:013] nttrd: socket 292 had bytes read=15
Between Receive and Send
[000001 17-JAN-2006 10:22:41:325] nioqrc: exit
[000001 17-JAN-2006 10:22:54:014] nioqsn: entr
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"
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