Table ı kimin locked ettiğini hemen bulun
SELECT a.session_id,a.oracle_username,
a.os_user_name,
b.owner "OBJECT OWNER",
b.object_name,
b.object_type,
a.locked_mode
FROM (SELECT object_id,session_id,
oracle_username,
os_user_name,
locked_mode
FROM v$locked_object) a,(
SELECT object_id, owner, object_name, object_type FROM dba_objects) b
WHERE a.object_id = b.object_id
Not : Faruk Hocam a teşekkürler
Hiç yorum yok:
Yorum Gönder