Monday, March 11, 2013

Query to find locked objects in Oracle


SELECT   c.owner, c.object_name, c.object_type, b.sid, b.serial#, b.status,
         b.osuser, b.machine, b.program, b.module, b.action
    FROM v$locked_object a, v$session b, dba_objects c
   WHERE b.sid = a.session_id AND a.object_id = c.object_id
ORDER BY module

No comments:

Post a Comment