To Check Locked Objects In Applications
SELECT distinct 'alter system kill session'''||vs.sid||','||vs.serial#||''';'
,vs.USERNAME
,fu.user_name
,ACTION
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 vlocked.object_id = c.object_id
AND vs.paddr = vp.addr
AND vp.spid = fl.process_spid(+)
AND vp.pid = fl.pid(+)
AND fl.user_id = fu.user_id(+);
No comments:
Post a Comment