Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Oracle 7 locking
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