Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to know what table is locked

How to know what table is locked

From: Agung Kurniawan <agung_at_sarijayasecurities.com>
Date: Wed, 11 Apr 2001 19:03:53 +0700
Message-ID: <p08B6.231$g7.2212@news>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US