Clients leaving locks??

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 Received on Thu Nov 14 1996 - 00:00:00 CET