Re: Grabbing sequence values blocks in consecutive order: Need a guaranteed method.
From: Amar Kumar Padhi <amar.padhi_at_gmail.com>
Date: Wed, 25 Mar 2009 08:01:13 +0400 (GST)
Message-ID: <27518598.21237953482822.JavaMail.seven_at_aomfe1p1>
Another method would be to make use of application locks to actually create serial access to sequences. This can be achieved by using dbms_application_info to update v$session and then referring this value for releasing resources to one session at a time. I have used this logic in different scenarios to avoid two sessions from using the same resource. has worked perfectly.
Date: Wed, 25 Mar 2009 08:01:13 +0400 (GST)
Message-ID: <27518598.21237953482822.JavaMail.seven_at_aomfe1p1>
Another method would be to make use of application locks to actually create serial access to sequences. This can be achieved by using dbms_application_info to update v$session and then referring this value for releasing resources to one session at a time. I have used this logic in different scenarios to avoid two sessions from using the same resource. has worked perfectly.
Thanks!
Amar
Www.amar-Padhi.com
-original message-
Re: Grabbing sequence values blocks in consecutive order: Need a guaranteed method.
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 24 2009 - 23:01:13 CDT