Re: 61-62 second hangs over sql*net (805 to 8162 and 816 to 8162)

Could this be an effect of the algorithm used to minimise network traffic ( ?? the Nagle algorithm).

At some layer in the protocol the if a small message is to be sent the system waits in case there is further data to go before sending the message.

Depending on versions of Oracle and operating system there are a couple of parameters scattered around the place that can be set - the names are something like 'tcp_nowait' or 'tcp_wait_time'. Sorry I can't be more specific.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases

Publishers:  Addison-Wesley
See a first review at:
http://www.ixora.com.au/resources/index.htm#practical_8i
More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



NetComrade wrote in message <3a43c432.598431348_at_news.earthlink.net>...


>We are gettingweird performance problems with our application ,and

>while trying to figure out what is going on , we

>discovered weirddatabase hangs when doing a simple query over db_link.

>We wrote a PL/SQL block that would execute the query and if the query

>took more then one second tocomplete, we would write that to a log

>file. The weird part is that whenever itwas more then 1 second it

>would be 61-62 seconds, usually it would take milliseconds to

>complete. the problem could be reproduced over with a pro*c

>application accessing database thru sql*net.

>So far we took out of configuration dns (put in straight ips),

>protocol.ora.

>This problem is not database specific, and can be reproduced in our

>dev and live environments which are on separate networks.

>

>The hangs are _always_ 61-62 seconds. (and then the query would

>return)

>

>THanx.

>---------------

>In case I forgot to mention:

>We use Oracle 7.3.4 and 8.1.6 on Solaris 2.6, 2.7 boxes

>---------------

>Andrey Dmitriev eFax: (978) 383-5892  Daytime: (917) 750-3630

>AOL: NetComrade ICQ: 11340726 remove NSPAM to email