Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQL *Net more data from client - waiting too long

RE: SQL *Net more data from client - waiting too long

From: Kerber, Andrew <>
Date: Tue, 9 Jan 2007 10:37:42 -0600
Message-ID: <>

It also means its not a problem w/ Oracle, it's a problem with the application.  

Andrew W. Kerber
Oracle DBA
UMB     "If at first you dont succeed, dont take up skydiving"

-----Original Message-----
[] On Behalf Of Niall Litchfield Sent: Tuesday, January 09, 2007 10:35 AM To:
Subject: Re: SQL *Net more data from client - waiting too long  

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 <> 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.  



Niall Litchfield
Oracle DBA 

NOTICE:  This electronic mail message and any attached files are confidential.  The information is exclusively for the use of the individual or entity intended as the recipient.  If you are not the intended recipient, any use, copying, printing, reviewing, retention, disclosure, distribution or forwarding of the message or any attached file is not authorized and is strictly prohibited.  If you have received this electronic mail message in error, please advise the sender by reply electronic mail immediately and permanently delete the original transmission, any attachments and any copies of this message from your computer system. Thank you.


Received on Tue Jan 09 2007 - 10:37:42 CST

Original text of this message