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
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