Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 61-62 second hangs over sql*net (805 to 8162 and 816 to 8162)
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.
Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 750-3630 AOL: NetComrade ICQ: 11340726 remove NSPAM to emailReceived on Fri Dec 22 2000 - 15:15:31 CST