Re: (Java) Synchronizing multiple app servers through Oracle

On Dec 13, 11:13 pm, chrism..._at_gmail.com wrote:
> 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.

I'd say that's pretty long. How often will you - pardon, your application - acquire the lock and what's the general load pattern of the application?

Kind regards

robert Received on Fri Dec 14 2007 - 02:08:45 CST