We have an intermittent problems with communications between clients and Oracle servers (both Windows.) We may see ORA-12170: TNS:Connect timeout occurred or ORA-03113: end-of-file on communication channel. When this happens there is no error on the Oracle server. We believe it is a network issue but we can't make it happen on demand and haven't been able to diagnose.

Sometimes a multi-user application using a session with ThreadSafe = true just hangs without generating an exception; it seems that the client waits indefinitely, and requests from other threads back up behind it. Should SQLNET.RECV_TIMEOUT and SEND_TIMEOUT help? If we used a TOracleSessionPool with a timeout set, would it terminate the thread?

Thanks or any suggestions.