"For Update no Wait" and Database Sessions.

Hello,
I have (i think) a trouble with Oracle lock/sessions: Normally I use FOR UPDATE NOWAIT to acquire a lock on rows. I've simulated client crash without problem (the rows was correctly unlocked).
The problem come when, after locked some rows, i have unplugged out the client net cable.
This results in a Database Session alive in Oracle that lock my rows for unspecified time; and this session rest alive also after reconnecting client cable and terminating the application who generated the conection.

I use Tcp/ip protocol for the connections between machines and all my queries are under transaction.

I suppose Oracle knows when the client is disconnected (tcp connection results in time out), so i'm interrogating about this restless session. Actually i have to "disconnect immediate" manually and i'd like to avoid this workaround.

Another question: during my tests, it seems that, casually, in a token ring environnement the connection between Client and Oracle server get lost and resulting in above behaviour. Any experiences about?

thanks and sorry for my dreadful english <x:termoPilucco> Received on Thu Nov 20 2003 - 05:30:38 CST