find what user has a row locked for update??

From: <jeffchirco_at_gmail.com>
Date: 20 May 2005 14:51:47 -0700
Message-ID: <1116625907.484180.263960@g43g2000cwa.googlegroups.com>

Is there a way to find out what user has a lock on a record? I am performing a lock on a record by doing a for update nowait in my select statement. I want to get down to the row that is locked in that table.  I have found that I can see what user has a record locked on a table by executing:
select
  oracle_username,
  os_user_name,

  locked_mode,
  object_name,
  object_type

from
  v$locked_object a,dba_objects b
where
  a.object_id = b.object_id;

Is there a way to find out which record that user is locking? Say an ID field.
Thanks.

Jeff Chirco Received on Fri May 20 2005 - 16:51:47 CDT