sql script to check from DML lock

select t1.sid "SID", s.username, s.osuser, s.program,
s.machine, o.object_name, t1.ctime
from v$lock t1, v$session s, dba_objects o
where
t1.type='TM' and
t1.sid = s.sid and
t1.id1 = o.object_id
order by t1.sid, t1.ctime;
Reply With Quote