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

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) Received on Fri Nov 23 2007 - 12:30:01 CST