Using custom application locks
- From: Amar Padhi <amar.padhi@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 27 Mar 2009 00:10:46 +0400
This thread is started to explain creation of custom application locks to
handle serialization of a process or set of processes across multiple
commits. This was debated in another thread as not being reliable (thread
with subject "Grabbing sequence values blocks in consecutive order: Need a
guaranteed method."). I just quickly wrote and posted some sample code at
below link to show how this method works. You can try running it against
your cases and let me know if this fails to deliver.
http://www.amar-padhi.com/oradb_application_lock.html
All comments welcome. Thanks.
--
Amar Kumar Padhi
Oracle DBA/Architect
www.amar-padhi.com
Other related posts:
