SELECT do.owner,
do.object_name,
do.object_type,
dl.session_id,
vs.serial#,
vs.program,
vs.machine,
vs.osuser
FROM dba_locks dl,
dba_objects do,
v$session vs
WHERE do.object_name LIKE 'WF%'
AND do.object_type = 'TABLE'
AND dl.lock_id1 = do.object_id
AND vs.sid = dl.session_id
do.object_name,
do.object_type,
dl.session_id,
vs.serial#,
vs.program,
vs.machine,
vs.osuser
FROM dba_locks dl,
dba_objects do,
v$session vs
WHERE do.object_name LIKE 'WF%'
AND do.object_type = 'TABLE'
AND dl.lock_id1 = do.object_id
AND vs.sid = dl.session_id
Comments
Post a Comment