1. Get unlimited access to documents by upgrading to Premium Membership.
  2. We are not accepting new members currently. If you would like to join, please contact us.
    Dismiss Notice
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]