Lock Issue

[ckwan]

Hi everyone,
Just something to share with all of you. I found that if two machine at the same time update the same row of the tables, both machine will hang. If one of the machine switch off adnormally, the other machine still locked by the other machine - system not release the lock.

The solution is set sqlnet.expire_time = <n minutes> in the sqlnet.ora in SERVER.

If you have the Oracle Metalink access, you can check the document number :1018106.6 to find out further.


Thanks

[jgmagnus]

so what do you set: sqlnet.expire_time to???

- Magnus

[apfaunts]

sqlnet.expire_time is a parameter in the sqlnet.ora file. It enabled Dead Connection Detection (DCD).
Dead Connection Detection (DCD) is a feature of SQL*Net V2.1 and later. It detects when a partner in a SQL*Net V2 client/server or server/server connection has terminated unexpectedly, and releases the resources associated with it. You set it to a value in minutes. So 1 means one minute, 5 - five minutes etc.
Note:1013364.6 gives more details.

[sreddy]

If you set sqlnet.expire_time = xx, the problem here z even if the user doen't want to get disconnected... say he was referring to some documents while his session is on, he will be disconnected and annoying what the hell happened. you have to justify... the time for sqlnet.expire_time. Just a reminder...

[ckwan]

Yap ! you all right !