TCP connections linger in Delphi

[S. Geeroms]

Hi,

When I disconnect my Oracle Session I see that the correspondig TCP connection lingers and stays in a state "TIME_WAIT" (using netstat).

Is there a way to make it so that the connections are immediatly freed on disconnection?

Versions:
DOA : 4.1.2.0
Oracle Client : 11.1.2

 

[Marco Kalter]

Direct Oracle Access performs a logoff when you disconnect the session. There is nothing more it can do. Maybe there is some Oracle Net configuration that allows you to control how it deals with TCP connections, but I'm not aware of it.

 

[S. Geeroms]

Ok, thanks.

I guess that the TOracleSession than also doesn't care about connection timeouts, and it is also a Oracle Net issue. Because we have sometimes that a connection waits "eternily" for a connection. We get the BeforeConnect event, but after that nothing mores happens and the oracle connection just hangs...

regards,
Steve

 

[Marco Kalter]

The TOracleSession component calls the Oracle Call Interface functions OCIServerAttach and OCISessionBegin to make a connection. These functions do not have a time-out option, so if such a function call does not return then there is not much that can be done.