查询阻塞与被阻塞SQL语句,供参考:
select b.sid,
a.sql_id,
a.sql_text,
a.hash_value,
b.username,
b.machine,
a.module,
decode(c.block,1,'blocking') blocking,
decode(c.request,0,'null','blocked') blocked,
to_char(b.logon_time, 'yyyy-mm-dd hh24:mi:ss')
from v$sql a,v$session b,v$lock c
where c.type='TX'
and a.sql_id = b.sql_id
and b.sid=c.sid
union all
select b.sid,
a.sql_id,
a.sql_text,
a.hash_value,
b.username,
b.machine,
a.module,
decode(c.block,1,'blocking') blocking,
decode(c.request,0,'null','blocked') blocked,
to_char(b.logon_time, 'yyyy-mm-dd hh24:mi:ss')
from v$sql a,v$session b,v$lock c
where c.type='TX'
and a.sql_id = b.prev_sql_id
and b.sid=c.sid and c.block=1
select b.sid,
a.sql_id,
a.sql_text,
a.hash_value,
b.username,
b.machine,
a.module,
decode(c.block,1,'blocking') blocking,
decode(c.request,0,'null','blocked') blocked,
to_char(b.logon_time, 'yyyy-mm-dd hh24:mi:ss')
from v$sql a,v$session b,v$lock c
where c.type='TX'
and a.sql_id = b.sql_id
and b.sid=c.sid
union all
select b.sid,
a.sql_id,
a.sql_text,
a.hash_value,
b.username,
b.machine,
a.module,
decode(c.block,1,'blocking') blocking,
decode(c.request,0,'null','blocked') blocked,
to_char(b.logon_time, 'yyyy-mm-dd hh24:mi:ss')
from v$sql a,v$session b,v$lock c
where c.type='TX'
and a.sql_id = b.prev_sql_id
and b.sid=c.sid and c.block=1
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10271187/viewspace-1658097/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10271187/viewspace-1658097/