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

From: FmHabash <fmhabash_at_gmail.com>
Date: Wed, 25 Mar 2009 11:00:53 -0400
Message-ID: <49ca4729.1cbc720a.14b9.fffff5c8_at_mx.google.com>

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_at_gmail.com> Sent: Wednesday, March 25, 2009 12:01 AM To: oracle-l_at_freelists.org
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-

 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 Received on Wed Mar 25 2009 - 10:00:53 CDT