Sunday, March 30, 2014

How to check locked object in oracle

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;

No comments:

Post a Comment