Re: Question Regarding MTS Server Behavior

Phil Singer <psinger1_at_chartermi.net> wrote in message news:<3EDB265B.68CCF69E_at_chartermi.net>...
> We are using a 8.1.7. dedicated server configuration, with
> ADO managing connection pools. At unpredictable moments,
> the latency in out TCP network increases to where
> connections start timing out. When this happens, ADO
> thinks the sever has dropped it, and never uses that
> connection again, while Oracle waits for DCD to happen

Best would be to solve the network problem ;-) I don't know about the mts behaviour in this situation but why not just make the expire_time shorter ? (sqlnet.expire_time=N) N in minutes.
It could as well make things a little worse since it is generating some extra traffic ...

regards,
Ronald.