Oracle lock timeouts
From: Charlie Toor <hfraser_at_dqc.dofasco.ca>
Date: 3 Aug 93 09:38:17
Message-ID: <1993Aug3.093818.3498_at_eisgen'.dofasco.ca>
Date: 3 Aug 93 09:38:17
Message-ID: <1993Aug3.093818.3498_at_eisgen'.dofasco.ca>
We are running Oracle 7 on an HP/UX box with Powerbuilder as a PC client tool. Occasionally, a PC will crash (?) or otherwise do an unclean disconnect from the database (connect via TCP/IP to the PC clients), often leaving records locked. It appears that somewhere in the Oracle<->SQL server<->HP TCP/IP<->FTP Software<->Powerbuilder string somethingof packages, Oracle fails to recognize the connection has been dropped and doesn't release the record locks. It's been suggested that we put 30 minute timeouts on the locks, but that seems to be a crude solution and in any event is quite intolerable for production environments. Does anybody have any other suggestions? Received on Tue Aug 03 1993 - 09:38:17 CEST