Using custom application locks

From: Amar Padhi <amar.padhi_at_gmail.com>
Date: Fri, 27 Mar 2009 00:10:46 +0400
Message-ID: <4064db340903261310n2efb759dh424d99457ac6a61f_at_mail.gmail.com>



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

--

http://www.freelists.org/webpage/oracle-l Received on Thu Mar 26 2009 - 15:10:46 CDT

Original text of this message