select a.object_id,a.object_name,b.sid,b.serial#,b.username,
c.os_user_name,c.locked_mode
from v$session b, v$locked_object c , dba_objects a
where a.object_id=c.object_id and
b.sid=c.session_id;
|
Results 1 to 5 of 5
Thread: How do I find table Locks?Threaded View
|
Click Here to Expand Forum to Full Width |