Is there any way to find out what session/user has the lock on the row that I
want to lock for update (when getting, for example, a resource_lock exception)?
Oracle 7.2, AIX 4.1.5 on RS/6000 SP2. We have queries that show all locks, and
I can narrow it down to all locks on a table, but is there any way to get the
one user who has the row that I want? Have talked to Oracle support on this,
they deny that it is possible or knowledge of how it could be done. My thought
is, if the server can figure this out (from the V$ tables, I suppose) I should
be able to.
Thanks,
Thomas
Received on Sat Jul 11 1998 - 22:00:14 CDT
