status column of Netstat on Windows 2000
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: status column of Netstat on Windows 2000

  1. #1
    Join Date
    Aug 2001
    Posts
    11
    I know this not the appropriate forum, however I am under the impression that many DBA's use 'netstat' command.
    how to interpret the results of NETSTAT on WINDOWS2000
    I found following values for status column when I used
    'netstat' command.

    listening,established, time_wait.

    What does time_wait indicate? where can I find the detail information of this command.

    Thanks in advance.

    joedba

  2. #2
    Join Date
    Jan 2001
    Posts
    3,131
    Netstat--Notes

    The Netstat utility provides statistics on the following network components.
    Foreign Address
    The IP address and port number of the remote computer to which the socket is connected. The name corresponding to the IP address is shown instead of the number if the HOSTS file contains an entry for the IP address. In cases where the port is not yet established, the port number is shown as an asterisk (*).
    Local Address
    The IP address of the local computer, as well as the port number the connection is using. The name corresponding to the IP address is shown instead of the number if the HOSTS file contains an entry for the IP address. In cases where the port is not yet established, the port number is shown as an asterisk (*).

    Proto
    The name of the protocol used by the connection.
    (state)
    Indicates the state of TCP connections only. The possible states are

    CLOSED FIN_WAIT_1 SYN_RECEIVED
    CLOSE_WAIT FIN_WAIT_2 SYN_SEND
    ESTABLISHED LISTEN TIMED_WAIT
    LAST_ACK

    That's all I got
    MH

  3. #3
    Join Date
    Aug 2001
    Posts
    11
    Thank you Hanky for the reply. what does Timed_wait status
    indicate. The reason why I am asking this is when open a session from sql plus and closes the status of the connection
    is reported as TIMED_WAIT. When I checked v$session it is
    terminated. If it is terminated what is timed_wait status in netstat utility.

    Thanks.
    joedba

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width