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