It means exactly what it says, the session is awaiting data from the client (probably the app server. You can most likely address this by 1. sending more data at once - hence Jared's suggestion to get the network admin involved I guess - this involves mtu settings from memory (to be honest networks are mostly electric string with flashing lights to me, sorry). 2. changing the app to be more efficient with its data transfers. On 1/5/07, dd yakkali <dd.yakkali@xxxxxxxxx> wrote:
I have a developer 6i forms application, when they search on one particular screen, screen intermittently hangs for about 3 to 4 minutes. when I look at the back end the session is waiting on "SQL *Net more data from client" event for more than 3 minutes. While this freeze is going on, I had the user do a tnsping and regular ping to see whether there is a network hiccup, none was found. Can any one please explain me what "SQL *Net more data from client" event means. What can I do to drill more into this issue? any help is greatly appreciated. Thanks Deen
-- Niall Litchfield Oracle DBA http://www.orawin.info