View List of Locked Objects

From Relyimah

To view a list of currently locked objects, run the following query:

SQL Query:

SELECT
    c.owner,
    c.object_name,
    c.object_type,
    b.sid,
    b.serial#,
    b.STATUS,
    b.osuser,
    b.machine
FROM
    v$locked_object a ,
    v$session b,
    dba_objects c
WHERE
    b.sid = a.session_id
AND
    a.object_id = c.object_id