On Dec 13, 4:07 am, Robert Klemme <shortcut..._at_googlemail.com> wrote:
> On Dec 13, 2:10 am, chrism..._at_gmail.com wrote:
>
> > What is the recommended way for using an Oracle database to
> > synchronize multiple app servers? When I speak of synchronizing, I'm
> > referring to the Java use of the word, where you can lock a section of
> > code so other threads don't access that section at the same time.
>
> > I have multiple app servers that each need exclusive access to the
> > database for a certain operation. Does Oracle have a semaphore
> > utility that is available to apps? I know I could hack it by doing a
> > select for update on a dummy table with 1 row, but I was hoping Oracle
> > had something more elegant to use.
>
> Hopefully you are aware that this may cause a major bottleneck in your
> application. This kind of global lock should not be used too frequent
> and for too long.
>
> Kind regards
>
> robert
Typically the lock will last less than one second.
Received on Thu Dec 13 2007 - 16:13:51 CST
