> > 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?
>
Yes, it's not that short of a period of time, but unfortunately,
that's how long it takes to grab unique records. Right now we have 2
app servers each hitting the database once per second and acquiring a
lock. However, the number of app servers could grow to 10 or more. I
wrote a multi-threaded test to simulate multiple servers, and found
that Oracle appears to have a problem when more than 10 locks are
acquired at the same time. It seems to just give up and wait for the
timeout once too many have been acquired. Is there a setting in
Oracle to handle more simultaneous locks?
Received on Wed Dec 19 2007 - 14:05:42 CST
