Wait event "SQL*Net more data to client" in wait class "Network" Options
Recently my database reported problem on wait event "SQL*Net more data to client". When this wait event occurred, it will look like “hanging” at this wait event until we killed the session and restart the client application container that used the session. I'd check on the query and the data return to client is very small. I also did check the network, and everything is working fine as well.
I am using Oracle 10.2.0.3.0, running on Window Server 2003 x64. Client (application server) and database server is in same network and there is no firewall in between.