Re: how to test locks

On Wed, 23 Jan 2002 21:52:33 -0500, Jim Kennedy wrote:

> What are you trying to accomplish? Since readers don't block writers and
> writers don't block readers the only condition I can see where you want
> to see if it is locked is when you want to lock it because you are going
> to update it. Otherwise, what is the purpose? You could do as they
> suggest and if it does NOT error out (meaning you got the lock) then
> issue commit and release it. You could even put it in a package as a
> function and return 1 for locked and 0 for not locked.
>
>

Who, me? I just responded to a question. In oracle you can't determine whether the row in of your fancy is is locked or not without issuing your own lock for a moment. That amounts to the oracle version of the uncertainty principle: you can't measure things without disturbing them. That's all. My response was formulated under the influence of fact that it was my 3rd night without much sleem (this is the 4th one) and being a DBA,I have as likable and charming personality as can normally be expected. Sleep deprivations worsens things even further.That's about it. Received on Thu Jan 24 2002 - 01:09:59 CST