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.

Recipe #1 - Query locked database objects

The following query shows you all locked objects 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;