Re: Wait event "SQL*Net more data to client" in wait class "Network"

On Fri, 23 Nov 2007 10:30:01 -0800 (PST), chris <cboivin_at_jlr.ca> wrote:

>Hi,
>
>Starting last week my application got problem "SQL*Net more data to
>client"
>1 connection on 10 hang for about 10 secondes.
>
>I'd check the network, and everything is ok, and the problem is
>randomly
>yesterday afternoon, everything go fine, this morning it hang a lot
>
>My env :
>Oracle 10.2.0.3 std 64bit
>Win 2003 ent 64bit
>VB 6 app design "Just-in-time" connection
>connect via microsoft ODBC
>
>I have 4 websites connecting on the same instance, with no problem
>and same design ...
>
>The only difference between website and the vb6 app is the network
>segment
>website and Db are on the same network segment (DMZ) and the app is
>in
>the Intranet (Inside interface)
>
>I'll monitor my FW to see if something wrong ... but change nothing on
>this recently
>
>If someone have seen this, maybe have a solution ...
>
>Thank you
>Chris
>(sorry if my english is poor)

sql*net more data to client means your data doesn't fit in one sqlnet packet. The default packet size is 2k. You can adjust this by setting the SDU on listener and client tnsnames.ora. The SDU needs to be a multiple of the network card MTU, usually 1500 bytes.

-- 
Sybrand Bakker
Senior Oracle DBA