Great article!

What happens when two or more instances of the same application are running, is the lock mechanism handled at database level or application level?