Problem

Finding locked database object

What do you usually do when you detect a lock in your database? You have to get more information about the problem. Knowing about the object which caused the lock can often help you locate the problem very quickly.

Solution

Recipe #1 - Query locked database objects

The following queries shows you all locked object including some information about the session causing the lock. The combination of these things should make it easy to spot and fix the problem.

SELECT DO.owner,
       DO.object_name,
       DO.object_type,
       lo.session_id,
       lo.oracle_username
  FROM dba_objects DO, v$locked_object lo
WHERE DO.object_id = lo.object_id