Oracle Database Discussions

dear team,

My request is to find a way to kill a session when a client connection got disconnect. below is the scenario:
USER1 is a client PC connected for 2min and then got disconnect due to network cable disconnection (and not abnormal close of any application)
USER2 is a client PC is always connecting to the database but without activity which is required (in case the user is a manager)

the EXPIRE_TIME is configured for 2min (at the server level)

the behavior is that when checking these 2 sessions i always see both of them even after the disconnection of the USER1.
After waiting 5 min the USER1's session still not killed, which means that the expire_time is not taking effect.
After reconnecting the USER1 to the network the session will be killed after 2min, and here we came by a conclusion saying that the expire_time will not take effect unless the PC is reconnected to the network.

we tried the KEEPALIVE time (OS parameter) for 2 min but still the same issue.
After around 10 min the session is automatically killed (when the client PC was disconnected) without knowing the reason.

Could you please help me to find a solution for such disconnection issue.


By the way, i'm using Oracle 10gR2 E. E. on Linux RHEL 5 machine
thx in advance
Regards
Elie

Edited by: Elie on Oct 15, 2010 6:47 PM

Edited by: Elie on Oct 15, 2010 8:04 PM