Re: Commit without freeing locks

Thank you for your help!

After a look to my oracle manual i found another possible way of solving my problem.

Oracle supplies a DBMSLOCK pakage that contains a few functions and procedures able to create a lock structure in the oracle server.

It should be possible to generate a unique lock id based on the rowid of the table and row i want to lock and to use this id to set and query the lock with the appropriate function in DBMSLOCK.

This method seems to be also quite safe bacause the package itself takes care of freeing locks if the session aborts.

Using a lock field in the table has exactly this problem. If the session that set the lock field abort without beeing able to free lock field it is not trivial to find a nice restart mechanism that frees all locks of no longer existing sessions.

Any comments and ideas to this approach?

Dieter Oberkofler
Director of Engineering

LEADING BITS GmbH.               Tel             (+43-1) 586 76 11
Schleifmuehlgasse 5/17           Fax             (+43-1) 587 76 15
A-1040 Vienna                    E-mail     dtr_at_leadingbits.via.at
Austria                          Compuserve            100141.1314


------------------------------------------------------------------

Dieter Oberkofler
Director of Engineering

LEADING BITS GmbH.               Tel             (+43-1) 586 76 11
Schleifmuehlgasse 5/17           Fax             (+43-1) 587 76 15
A-1040 Vienna                    E-mail     dtr_at_leadingbits.via.at
Austria                          Compuserve            100141.1314


------------------------------------------------------------------