Re: Clients leaving locks??

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

I have two questions

1. Are you using SQL*Net V2.
2. Why is the PC crashing.