Re: How to know what table is locked

Do a select on v$lock (as sys(tem)). Look at the object ids and get the names from dba_objects. Note that v$lock also has a column (blocker or something) that indicates that it is actually locking someone else out.

Len

>Oracle 8i (8.1.5)
>
>Suppose user A is running a very long process that updates a row in table T1
>(the process is still running and the transaction is not Commit-ed yet).
>Right after that, user B runs a process that is updating the same row in
>table T1. User B's process than will be hold until user A's process commits
>its transaction.
>
>My question is, is there a way to know what table is being locked (and by
>whom)?
>
>Thanks,
>
>Agung
>
>
Received on Fri Apr 13 2001 - 15:19:36 CDT