查詢阻塞與被阻塞SQL語句
查詢阻塞與被阻塞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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- SQL Server阻塞查詢語句SQLServer
- MySQL查詢阻塞語句MySql
- Oracle中查詢阻塞與被阻塞SID的方法Oracle
- 查詢引起Oracle阻塞事件的源頭語句的方法Oracle事件
- HighgoDB查詢慢SQL和阻塞SQLGoSQL
- oracle session阻塞查詢OracleSession
- Oracle阻塞會話查詢Oracle會話
- Oracle阻塞(鎖等待)查詢Oracle
- 一條查詢Oracle中的阻塞鎖(以及阻塞在哪個資料上)的SQLOracleSQL
- SQL查詢語句 (Oracle)SQLOracle
- SQL server 查詢語句SQLServer
- SQL mother查詢語句SQL
- SQLServer DML操作阻塞SELECT查詢SQLServer
- row lock contention 阻塞程式查詢
- library cache lock 阻塞程式查詢
- library cache pin 阻塞程式查詢
- 阻塞IO與非阻塞IO
- SQL查詢語句使用 (轉)SQL
- sql 查詢經典語句SQL
- 同步與非同步 阻塞與非阻塞非同步
- 同步非同步 與 阻塞非阻塞非同步
- 同步、非同步、阻塞與非阻塞非同步
- RAC環境中的阻塞 查詢鎖
- postgresql dba常用sql查詢語句SQL
- SQL語句查詢表結構SQL
- mysql 查詢建表語句sqlMySql
- SQL查詢語句精華文章(轉)SQL
- [轉]阻塞/非阻塞與同步/非同步非同步
- Java NIO 阻塞式與非阻塞式Java
- oracle、my sql、sql隨機查詢語句OracleSQL隨機
- 同步與非同步、阻塞與非阻塞的理解非同步
- 使用 strace 查詢 Emacs 啟動阻塞的原因Mac
- Waiting for table阻塞查詢的問題AI
- SQL Server-簡單查詢語句SQLServer
- mysql查詢效率慢的SQL語句MySql
- SQL單表查詢語句總結SQL
- 查詢執行慢的SQL語句SQL
- SQL語句巢狀查詢問題SQL巢狀