Moderators , can u please look into this ?
Main Topics
Browse All Topicsmy solaris 10g netstat -s -P tcp output shows
netstat -s -P tcp
TCP tcpRtoAlgorithm = 4 tcpRtoMin = 400
tcpRtoMax = 60000 tcpMaxConn = -1
tcpActiveOpens =8541985 tcpPassiveOpens =6636375
tcpAttemptFails =1178102 tcpEstabResets =3970089
tcpCurrEstab = 353 tcpOutSegs =637870813
tcpOutDataSegs =4264494647 tcpOutDataBytes =4158460100
tcpRetransSegs =970083 tcpRetransBytes =752333425
tcpOutAck =782158233 tcpOutAckDelayed =162812268
tcpOutUrg = 1802 tcpOutWinUpdate =250042
tcpOutWinProbe = 22831 tcpOutControl =30072847
tcpOutRsts =4856638 tcpOutFastRetrans =158459
tcpInSegs =3515848471
tcpInAckSegs =2150305032 tcpInAckBytes =102418816
tcpInDupAck =111470035 tcpInAckUnsent = 0
tcpInInorderSegs =1902119247 tcpInInorderBytes =3071923912
tcpInUnorderSegs =37571088 tcpInUnorderBytes =3757513348
tcpInDupSegs =622698 tcpInDupBytes =376009442
tcpInPartDupSegs = 3469 tcpInPartDupBytes =2467874
tcpInPastWinSegs = 5 tcpInPastWinBytes = 6900
tcpInWinProbe = 1226 tcpInWinUpdate = 22357
tcpInClosed =3318785 tcpRttNoUpdate =172459147
tcpRttUpdate =1970102865 tcpTimRetrans =609222
tcpTimRetransDrop = 1108 tcpTimKeepalive =114978
tcpTimKeepaliveProbe= 3187 tcpTimKeepaliveDrop = 13
tcpListenDrop = 8341 tcpListenDropQ0 = 0
tcpHalfOpenDrop = 0 tcpOutSackRetrans = 806
what are the parameters I need to check to know if there are errors in my network. I see tcpListenDrop is non zero.
Please explain the important parameters to look for ? and what ndd parameters i need to change if needed
Thanks in Advance !
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Hi,
Hi, if tcpListenDrop increase means that your database is receiving a high number of connect request on database listener. Default value of max unfinished connections that can be handled by Oracle Listener simultaneously is 5.
To increase this value, use the QUEUESIZE parameter on listener.ora.
eg.:
[...]
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = XXXXX)(PORT = 1521)(QUEUESIZE = 64))
[...]
The max value that QUEUESIZE can be configured is limited by tcp_conn_req_max_q (default value is 128)
I think that queuesize in 64 will increase the listener throughput and avoid tcpListenDrop.
Regards
The application running on the box is WebSphere and WebSphere MQ with some java applications. Regarding uname -a , i will check it on monday as today i dont have access.(its a Sun Solaris 10.g box)
There is also oracle client on the box which connects to over 20 Oracle 10g (with RAC) databases via JDBC
uname -a SunOS red 5.10 Generic_118833-18 sun4v SUNW, Sun-Fire-T200,
applications affected :WebSphere
I think bitti's answer is close , the only thing is this is not a oracle server. It looks like my server may be receiving more requests from the webserver. I still want to analyse the errors in the netstat output .
ModEErf,
I appreciate gheist efforts to answer my question. As you can see I have already given the reason for awarding C .
netstat -s -P tcp output has lots of parameters to be analysed. The answers I got were vague. I have also provided all the info required by gheist . I do understand , sometimes its not possible to give a satisfactory answer. There is a lot of tcp errors which creates issues to WebSphere and a deep dive analysis of the netstat output is needed to interpret not just one parameter (which i myself suggested)
Any other suggestions from the experts are welcome !
Thanks
wasadmin11
Business Accounts
Answer for Membership
by: gheistPosted on 2009-10-20 at 07:05:56ID: 25614236
/usr/sbin/ndd /dev/tcp tcp_ip_abort_cinterval
/usr/sbin/ndd /dev/tcp tcp_conn_req_max
what your observation means - conn_req_max connections was not served in 3min time, or there were more connections coming in.
First rise later to something like 1024 to offload TNS a bit using little kernel resources.
If that does not help - sometimes TNS is hopeless and probably needs more backends and they need more RAM.
PS this is a per-connection structure, you have to reastart TNS after changing system setting
If your clients are over slow or noisy links results ar fine. Some retransmits etc.