RE: Grabbing sequence values blocks in consecutive order: Need a guaranteed method.

I like this a lot. Will this work with connection pooling where physical 
connections are being reused.


-----Original Message-----
From: Amar Kumar Padhi <amar.padhi@xxxxxxxxx>
Sent: Wednesday, March 25, 2009 12:01 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Grabbing sequence values blocks in consecutive order: Need a       
guaranteed method.

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.

--
http://www.freelists.org/webpage/oracle-l



--
http://www.freelists.org/webpage/oracle-l


Other related posts: