Re: Oracle lock timeouts

Charlie Toor (hfraser_at_dqc.dofasco.ca) wrote:
: 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?

I have had the same problem with a Macintosh running SQLForms connecting to a Sun SS2. Oracle support (oxymoron?) said the only way to deal with this is to kill the process on the Sun that was created by your Macintosh connection which crashed. I'm afraid I have no better solution than that. I am not familiar with setting lock durations.

If you get any solutions/workarounds to this, please forward them to me if they are not posted.

Thanks,
Geo.

George Oliver
NRaD, Code 423
oliver_at_nosc.mil Received on Tue Aug 03 1993 - 18:32:52 CEST