Re: Lock on table

Hi,
You can see locks with Oracle TopSession and that's the easiest way. From dynamic view V$SESSION you can see row_wait_obj# - id of obj you waits for (you waits if value != -1). Knowing this id from V$LOCKED_OBJECT you can find sessions that can locks your one.
Peter Laursen wrote:

> Is there a way that i can see which tables have been locked and which
> sql-statements have caused the lock? Are there any tools I can use? Will
> TOAD do the trick for me?
>
> I am programming an application in Delphi4 using DOA and Oracle 8.0.4. A
> simple update statement hangs. I assume its waiting for a lock to be
> released, but I have no idea what caused the lock.
>
> What locks are there in Oracle? If one SQL-statement is reading from a
> table, would that cause an update on the same table to fail? It is not the
> commit that fails but the actual update.
>
> Thanks

Received on Mon Feb 08 1999 - 09:53:00 CST