Could not reserve record

From: Ajay Kothari <akothari_at_lipidata.com>
Date: Fri, 1 Sep 2000 14:16:24 +0530
Message-Id: <10606.116113@fatcity.com>

Hi Guru's,

Platform: ORACLE 7.3.4/ SCO-UNIX Open Server Release 5(5.0.2) / Forms 6 /Win-98

Problem Defination: When the transaction is being made on a particular record (Query,Update or Delete)Sometimes the transaction hangs and the same record cann't be queried, even after opening a new session to do the same. At this movement v$locked_object view shows locked entries for that session/process. When we kill the session by giving "Alter system kill session 'SID, Serial#' command, the locked transaction is executed and clear the entries from v$locked_object view.

Frequency of error: Very high

Error message(Forms): "Could not reserve record (2Tries) keep trying" with Yes or No options. 2 Tries increases upto n numbers on each hit.

Please suggest a appropriate solution of the problem immediately.

Thanks in advance
Ajay
Keep smile !!! Visit us at www.lipidata.com

---

Lipi Data Systems Ltd, Mumbai Received on Fri Sep 01 2000 - 03:46:24 CDT