Re: SQL *Net more data from client - waiting too long
- From: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
- To: dd.yakkali@xxxxxxxxx
- Date: Tue, 9 Jan 2007 16:35:03 +0000
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
Other related posts:
