RE: kill the procedure Call

Hi Rakesh,

Nice notes. However, you haven't mentioned the platform: The 'netstat' command, the tcp parameters mentioned and their configuation vary quite drastically across platforms. Was the original from a HP platform?

John Kanagaraj
> -----Original Message-----
> From: Rakesh Gupta [mailto:GuptaR_at_telecomsys.com]
> Sent: Thursday, March 21, 2002 7:59 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: kill the procedure Call
>
>
> If you are using unix, you have to play with tcp kernel parameters.
> We have tuned these parameters:
> tcp_ip_abort_interval the time it takes for an existing
> connection to be closed
> tcp_ip_abort_cinterval the expiration time for
> establishing a new connection
> tcp_time_wait_interval the length of time the server
> holds a connection in a TIME-WAIT state after the end of the
> connection
> tcp_keepalive_interval the time period in which the
> server will continue sending probes to determine whether a
> connection is still active
> tcp_conn_req_max_q the maximum number of completed connections
> tcp_conn_req_max_q0 the maximum number of connections with
> handshake incomplete
>
> Default values
>
> Parameter Default Recommended
> tcp_ip_abort_interval 4800000 (8 minutes) 60000 (1 minute)
> tcp_ip_abort_cinterval 180000 (3 minutes) 60000 (1 minute)
> tcp_time_wait_interval 240000 (8 minutes) 60000 (1 minute)
> tcp_keepalive_interval 7200000 (2 hours) 900000
> (15 minutes)
> tcp_conn_req_max_q 128 256
> tcp_conn_req_max_q0 1024 2048
>
>
> The best way to determine whether or not a system is having
> connection problems is to look at the output of the netstat
> -an command. The netstat -a command displays the current
> status of connections. With the addtional "n" option, the
> command does not attempt to resolve IP addresses as host
> names, both speeding up the output and making it more
> predictable. The following netstat command gives a quick
> summary of the number of TCP connections in each state.
>
> bash-2.01# netstat -anP tcp | tail +5 | awk '{print $7}' |
> sort | uniq -c
> 27 ESTABLISHED
> 6 IDLE
> 36 LISTEN
> 1 Remote -> ignore this line
> 1 SYN_SENT
> 24 TIME_WAIT
>
> For example, if you see a large number of connections in the
> TIME_WAIT state, this may indicate that you need to reduce
> your time wait interval (tcp_ip_time_wait_interval) to a
> smaller value. If you find many sockets in the FIN_WAIT_2
> state, your server is probably waiting for the final ACK from
> the client before moving to close these connections.
>
>
> Let me know if you need any more help and I will send you our
> document which describes the procedures to set these parameters.
>
> Thanks
> Rakesh
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rakesh Gupta
> INET: GuptaR_at_telecomsys.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Kanagaraj
  INET: john.kanagaraj_at_hds.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).