How to know who is locking rows .... Response

From: <scheuric_at_sprynet.com>
Date: 1997/03/13
Message-ID: <5g7p3i$42k@lal.interserv.com>#1/1

One way to determine who is locking your table is to look at the dba table DBA_DML_LOCKS. Then, match the SID with the one in V$SESSION table. If you are in a client-server environment, you will be able to identify who the offender is only if you have username = [somename] in the oracle.ini file. This name will show up as OSUSER in the v$SESSION table. If your version is 7.2 or below, then you will have to be sure that the version catdblock.sql is working and that the lock tables where created. If you don't have the fix. I have it and will be happy to email you with the solution.

-Sheilah Scheurich
DBA Received on Thu Mar 13 1997 - 00:00:00 CST