Re: zombies

Solaris 2.x does have a keepalive option. All the parameters can be access via the ndd command.

# ndd /dev/tcp \?

?                             (read only)
tcp_close_wait_interval       (read and write)
tcp_conn_req_max              (read and write)
tcp_conn_grace_period         (read and write)
tcp_cwnd_max                  (read and write)
tcp_debug                     (read and write)
tcp_smallest_nonpriv_port     (read and write)
tcp_ip_abort_cinterval        (read and write)
tcp_ip_abort_interval         (read and write)
tcp_ip_notify_cinterval       (read and write)
tcp_ip_notify_interval        (read and write)
tcp_ip_ttl                    (read and write)
tcp_keepalive_interval        (read and write) <<<<<------
tcp_maxpsz_multiplier         (read and write)
tcp_mss_def                   (read and write)
tcp_mss_max                   (read and write)
tcp_mss_min                   (read and write)
tcp_naglim_def                (read and write)
tcp_old_urp_interpretation    (read and write)
tcp_rexmit_interval_initial   (read and write)
tcp_rexmit_interval_max       (read and write)
tcp_rexmit_interval_min       (read and write)
tcp_wroff_xtra                (read and write)
tcp_deferred_ack_interval     (read and write)
tcp_snd_lowat_fraction        (read and write)
tcp_sth_rcv_hiwat             (read and write)
tcp_sth_rcv_lowat             (read and write)
tcp_dupack_fast_retransmit    (read and write)
tcp_ignore_path_mtu           (read and write)
tcp_rwin_credit_pct           (read and write)
tcp_rcv_push_wait             (read and write)
tcp_smallest_anon_port        (read and write)
tcp_largest_anon_port         (read and write)
tcp_xmit_hiwat                (read and write)
tcp_xmit_lowat                (read and write)
tcp_recv_hiwat                (read and write)
tcp_fin_wait_2_flush_interval (read and write)
tcp_co_min                    (read and write)
tcp_status                    (read only)
tcp_bind_hash                 (read only)
tcp_listen_hash               (read only)
tcp_conn_hash                 (read only)
tcp_queue_hash                (read only)

Tim

---

P.S What space leaks - do you mean the VM system memory level goes down? If you
have the DB on the file system then this is just normal UNIX file cacheing.


In article qfc_at_casper.spirit.com.au, jmarcus_at_spirit.com.au (John Marcus) writes:


>jfruetel_at_ainet.com (John Fruetel) wrote:


>

>>tbellavia_at_riatax.com wrote:

>

>

>>>*** Tom Bellavia *** Research Instatute Of America Valhalla NY.

>>>I have oracle 7.1.4 both versions of sqlnet 1 & 2 running. I am a sun1000E

>>>Solaris 2.4 Platform. I have all the problems that everone else have (space

>>>leaks ect). What I have is a different problem. 

 


>>>We are a big client / server shop. 300 - 400 PC's over a sizable Wan 


>>>connection. I have alot of people doing ctrl + alt + del when the net is slow.

>>>Oracle (v1 of sqlnet) leaves these guys out there. Dropping the orasrv 

>>>connection at night not any help. I need a script that run under unix that 

>>>looks for zombies or dupl unix signon and blow them away. Anybody got any of 

>>>these or posible suggestions for resolution. Thanx ......

 


>>You might want to see if you can fiddle with the TCP/IP KEEPALIVE


>>option on your host.  I don't know about Solaris, but this can be

>>changed on SCO Unix from the default of two hours to something else (5

>>minutes in our case) and any "zombies" get nuked after 5 minutes.  

>>John Fruetel

>>jfruetel_at_ainet.com

>

>As far as we are aware, Solaris does not have a TCP/IP KEEPALIVE

>option (Unlike SunOS).  ORACLE WWS's only answer was to upgrade from

>SQL*Net V1 to  SQL*Net V2, which has "KEEPALIVE" built into it rather

>that relying on the O/S.  I'm yet to test this out yet...has anyone

>else got this working?

>

>

>John Marcus (jmarcus_at_spirit.com.au)

>Database Administration

>Australian Bureau of Statistics

>Canberra, Australia

>