Re: Clients leaving locks??

DONOVANA_at_LOGICA.COM (Andy Donovan) wrote:
>I'm sure this problem must have been solved before.
>
>Environment:
>Database: Oracle 7.2.3
>PC Client on LAN and Remote
>
>Problem:
>
>If a SqlWindows Client places a lock on the Database and then the PC
>crashes the lock remains on the DB. Consequently any other users that
>try to use the locked table will have to WAIT FOREVER!!. (Unless the
>friendly DBA kills the session). This seems a bit crap!
>Is there any neat way will can either:
>1) Kill the session on the Server when a client crahes
>2) Set a time out period for waiting for a lock(as in INFORMIX)
>
>Please help
>
>Andy
>

Hi there,

Specity SQLNET.EXPIRE_TIME in ORACLE_HOME/network/admin/sqlnet.ora.

If you set this value to non zero, then a process will wake up and clean all the hanging jobs.

For example, if you set this value to 5, then every 5 minutes a job will clean up all the hanging jobs.

I tried this in our environment DEC Alpha, it works.

Good Luck

N.Prabhakar
Socgen Crosby Securities
Singapore Received on Thu Nov 14 1996 - 00:00:00 CET