1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!
club

Query to find locked objects in daabase 2012-03-07

Query to find locked objects in daabase

  1. club
    [highlight=sql]


    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

    [/highlight]