[오라클] lock 걸린 table 및 sql찾기
페이지 정보
작성자 서방님 댓글 0건 조회 90회 작성일 09-01-30 16:43본문
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'
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'
댓글목록
등록된 댓글이 없습니다.
