Re: table locks

The id1 column of v$lock will for a table lock correspond to the object_id column of sys.dba_objects. Also the v$session table has carried three columns that equate to the rowid of the row being waited on since 7.2 for lockwaited sessions providing the session is waiting on a row level lock and not some type of resource or transaction lock.

If this is a test system I suggest you bounce the system and free all locks. It is quite probable that the lock is held by a runaway session since it has been held for three days!

Manvendra Jhala <mannyj_at_vspan.com> wrote in article <
> Hi all,
> developers are complaining that some records in a particular table have
> been locked for three days, and they want to know which user has it
> locked.
> I ve tried to query v$session + v$lock + dba_dml_locks but im not able
> to specify table_names at any point.
>
> am new to ora (7.3.4) .pls help
>
> thanks
> Manvendra
  Received on Fri Aug 21 1998 - 07:55:01 CDT