Re: Finding username of row level lock holder on 7.2

This does not seem to answer the question as to who is locking a specific row, just who (of which there could be many) has a lock on some row(s) in a table.

Does any one know how to determine the locking user at the row level?

Jim Reynolds
jbreynol_at_ix.netcom.com

In <32914F57.5B57_at_qrcsun.qrc.org> "Lun Wing San (Oracle)" <wslun_at_qrcsun.qrc.org> writes:
>
>rickhens_at_aol.com wrote:
>>
>> Does anyone know of a method of identifying the username of the
 holder of
>> a row lock ? None of the V$ tables seem to contain the needed
 information
>> to determine this. We are running version 7.2.
>
> SELECT OBJECT_ID, ORACLE_USERNAME, OS_USER_NAME, LOCKED_MODE FROM
 V$LOCKED_OBJECT;
>
> Related Topics: Read consistency
>
>---
>Name : Lun Wing San
>Title : Oracle Application Developer of Hong Kong Productivity
 Council
> Oracle Database Administrator and System Administrator of QRC
>Phone : (852)27885841
Received on Thu Nov 21 1996 - 00:00:00 CET