| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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). Received on Thu Mar 21 2002 - 09:58:41 CST
 |
 |