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.
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