Locked Tables and Rows - Response

 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