Re: Determining Locked user??
Date: 26 Nov 1994 08:02:21 GMT
Message-ID: <3b6q2d$q8k_at_astrakan.astrakan.se>
In article <allan.1136019098B_at_newshost.lanl.gov>, allan_at_apple.com (Allan Marcus) says:
>
>Is there any query I can use to determine which user is locking a particular
>row? I cannot seem to find anything about this in the manauls. If you give
>me the query and/or point me in the right direction...
>
I put that question to Oracle Support and they said it was impossible.
Maybe in some next version someday...
I did some trial and error testing...
If you have one session blocking a second session on a specific row lock, you can with a third session get the session id of the first session if you know the id of the second. Essentially the DBA_WAITERS view.
You could then tell Joe Smith that he is waiting for John Doe, however in my client environment (PC/Windows) I can not open a third session because a blocking second session locks up PC/Windows. I wish those responsible for SQL*Net 1.x had been somewhat more skilled Windows programmers...
If you want to do some testing on your own, try v$lock. The essential problem is to translate a ROWID into a resource identifier. So far I have had no success.
/Johan Received on Sat Nov 26 1994 - 09:02:21 CET