High 'SQL*Net message from client' when querying LOB tables (Doc ID 1590389.1)

Last updated on MARCH 09, 2023

Applies to:

Symptoms

Statements that involve tables with LOB data (CLOB or BLOB column) and that SELECT the LOB column are very slow and will take some time to finish. This is especially noticeable if the client is remote or on a WAN.
Increasing the SDU and/or increasing the number of fetched rows (in sqlplus 'set arraysize') will not make any difference.

Trace level 10046 and/or AWR reports will show the following SQL*NET wait events:
      SQL*Net message from client
      SQL*Net message from dblink
as top events in term of number of occurances ("Times Waited") and total time spent ("Total Waited").

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.