Re: Grabbing sequence values blocks in consecutive order: Need a guaranteed method.
- From: Amar Kumar Padhi <amar.padhi@xxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 25 Mar 2009 08:01:13 +0400 (GST)
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.
http://www.databasejournal.com/features/oracle/article.php/3321961/Use-Oracles-DBMSAPPLICATIONINFO-to-Prevent-Routines-from-Running-Simultaneously.htm
Thanks!
Amar
Www.amar-Padhi.com
-original message-
Subject: Re: Grabbing sequence values blocks in consecutive order: Need a
guaranteed method.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
