'[oracle]lock걸린 table 및 sql찾기'에 해당되는 글 1건

  1. 2009.10.20 [oracle]lock걸린 table 및 sql찾기
02.Oracle/DataBase2009. 10. 20. 19:58
반응형
select      b.username username,
              c.sid sid,
              c.owner object_owner,
              c.object object,
              b.lockwait,
              a.sql_text SQL
from        v$sqltext a, v$session b, v$access c
where     a.address=b.sql_address
and        a.hash_value=b.sql_hash_value
and        b.lockwait = 'WAIT'
and        b.sid = c.sid
and        c.owner != 'SYS'


출처 : http://ragew.tistory.com/3
Posted by 1010