Oracle'da Kilitli Nesneler ve Kilit Tutan Oturumlar

SELECT lo.session_id AS sid, s.serial#, s.username, s.status, s.machine,
       o.owner, o.object_name, o.object_type,
       DECODE(lo.locked_mode, 1,'NULL',2,'ROW SHARE',3,'ROW EXCL',4,'SHARE',5,'SHARE ROW EXCL',6,'EXCLUSIVE') AS lock_mode
FROM   v$locked_object lo
JOIN   dba_objects o ON o.object_id = lo.object_id
JOIN   v$session s   ON s.sid = lo.session_id
ORDER  BY o.owner, o.object_name;