Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How to know what table is locked
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 Wed Apr 11 2001 - 07:03:53 CDT