SELECT sid,
serial#,
username,
machine
FROM v$session
WHERE sid IN
(SELECT sid
FROM v$lock
WHERE id1 IN
(SELECT object_id
FROM dba_objects
WHERE object_name =
AND owner = ))

Comments are closed.