DB is facing problem regarding network delay:::
1004459Apr 22 2013 — edited Apr 22 2013Dear friends ,
Our DBA is facing bellow problem in their Data Base Server & they assume that this problem might happens due to Network problem ( LAN or WAN ) . But we didint find any problem regarding this in our LAN or WAN . I need your help in this regards
out put from DBA is :
tcp 0 0 db-scan:ncube-lm db-scan:26391 TIME_WAIT
tcp 0 0 db-scan:ncube-lm db-scan:26397 TIME_WAIT
tcp 0 0 db-scan:ncube-lm db-scan:26399 TIME_WAIT
tcp 0 0 db-scan:ncube-lm db-scan:26393 TIME_WAIT
tcp 0 0 db-scan:ncube-lm db-scan:26395 TIME_WAIT
tcp 0 0 db-scan:ncube-lm db-scan:26401 TIME_WAIT
tcp 0 0 db-scan:ncube-lm db-scan:26403 TIME_WAIT
tcp 0 0 vip1:47407 vip1:ncube-lm TIME_WAIT
tcp 0 0 vip1:22984 vip1:ncube-lm TIME_WAIT
tcp 0 0 vip1:22986 vip1:ncube-lm TIME_WAIT
tcp 0 0 localhost.localdomain:43979 localhost.localdomain:7938 TIME_WAIT
tcp 0 0 localhost.localdomain:51878 localhost.localdomain:44922 TIME_WAIT
tcp 0 0 vip1:11802 vip1:ncube-lm TIME_WAIT
tcp 0 0 vip1:11800 vip1:ncube-lm TIME_WAIT
tcp 0 0 localhost.localdomain:27701 localhost.localdomain:9373 TIME_WAIT
tcp 0 0 db1:35402 db2:50256 CLOSE_WAIT
getnameinfo failed
tcp 0 0 localhost:synchronet-db localhost:38078 TIME_WAIT
Anather Out Put :
Wait_class Wait Time second_In_wait State Wait_Time_micro Time_remain
1.Network 0 348708 waiting 34870752888 -1
2. Network 0 34860 waiting 3486045676 -1
3.Network 0 34860 waiting 3486045676 -1
4.Network 0 37860 waiting 3786045676 -1
5.Network 0 39860 waiting 3986045676 -1
6.Network 0 32860 waiting 3286045676 -1
Please help us to solved this problem .
Wait_Class 1. Network is related to LAN or WAN . DBA team insist that it related to LAN & WAN .