SELECT a.sid,a.serial#,a.terminal , a.username , a.osuser,
b.object_id,b.object_name
FROM
v$session a , dba_objects b, v$locked_object c
where a.sid=c.session_id
and b.object_id =c.object_id;
b.object_id,b.object_name
FROM
v$session a , dba_objects b, v$locked_object c
where a.sid=c.session_id
and b.object_id =c.object_id;
No comments:
Post a Comment