Wednesday, November 19, 2014

DB: Query: Locks on Objects in Database

SELECT sysdate, c.object_name Object_Name, fu.user_name, fu.description locking_user_name,
       fu.user_id, fl.start_time, vs.module, c.object_type, vs.machine, vs.osuser,
       vs.sid, vp.pid, vp.spid os_process_to_kill, vs.serial#, vs.status,
       vs.saddr, vs.audsid, vs.process
FROM   fnd_logins fl, fnd_user fu, v$locked_object vlocked,
       v$process vp, v$session vs, dba_objects c
WHERE  vs.sid     = vlocked.session_id
AND    vs.paddr   = vp.addr
AND    vp.spid    = fl.process_spid(+)
AND    vp.pid     = fl.pid(+)
AND    fl.user_id = fu.user_id(+)
AND    vlocked.object_id = c.object_id
AND    c.object_name like 'XX%'
ORDER BY 2

No comments:

Post a Comment