Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle 7 locking

Oracle 7 locking

From: Michael VanTyne <mvt_at_xmission.com>
Date: 2000/05/18
Message-ID: <39247406.F9692306@xmission.com>#1/1

I've got an Oracle 7.3.4.4 database running on a Sun E450 with a 3rd party Forms app. When users encounter an O/S error and have to reboot, their session is not killed and it keeps record and table locks within the database. When the user logs back in under a new session, the records from the previous session are still locked.

If I kill their original session myself, the server does a fine job of releasing the locked resources. My question is: what can I do to have PMON recognize and kill the dead session more quickly and automatically? Thanks in advance for any input.

Regards,
Michael VanTyne Received on Thu May 18 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US