Re: Clients leaving locks??

Bryan Jones wrote:
>
> 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:

If you're using SQL*Net v2.x, set the SQLNET_EXPIRE_TIME value to an acceptable value. The default is null (infinite), but 10 or 15 minutes might be acceptable in your environment.

This value is set in the sqlnet.ora file (usually in $ORACLE_HOME/network/admin or in /var/opt/oracle.

Good Luck!
Ken Shirey
Oracle Database Administrator
PrimeCo Personal Communications, LLP
kshirey_at_primeco.com
office (817) 258-1358
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Received on Fri Nov 15 1996 - 00:00:00 CET