Wednesday, 13 March 2013

To Find The Lock Tables In Oracle Apps

SELECT   c.owner,
         c.object_name,
         c.object_type,
         b.SID,
         b.serial#,
         b.status,
         b.osuser,
         b.machine
  FROM   v$locked_object a, v$session b, dba_objects c
 WHERE   b.SID = a.session_id AND a.object_id = c.object_id;


 =====================   ******************  ========================

SELECT c.owner,
c.object_name,
c.object_type,
fu.user_name locking_fnd_user_name,
fl.start_time locking_fnd_user_login_time,
vs.module,
vs.machine,
vs.osuser,
vlocked.oracle_username,
vs.SID,
vp.pid,
vp.spid AS os_process,
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 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(+)
--AND c.object_name LIKE '%' || UPPER ('&tabname_blank4all') || '%'
AND NVL (vs.status, 'XX') != 'KILLED'; 

No comments:

Post a Comment