23 Kas 2012

Lock olan table bulma

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