Re: Clients leaving locks??

set Sqlnet_expire_time = XXX does nor guarantee that connection will be clean. especiall if your are use 2.1 or 2.2 sql*net. Sql*net 2.3 is better. The other import thing is "pmon" need wake up to clean the connection, until now Oracle still NO guarantee "pmon" will wake up.

 Ken
Shirey (kshirey_at_spindle.net) wrote: : 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 Wed Nov 20 1996 - 00:00:00 CET