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

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-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Niall Litchfield Sent: Tuesday, January 09, 2007 10:35 AM To: dd.yakkali_at_gmail.com
Cc: oracle-l_at_freelists.org
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 <dd.yakkali_at_gmail.com> 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 


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

==============================================================================


--
http://www.freelists.org/webpage/oracle-l