Oracle DBA by Teshome Asfaw
A road to be an Oracle DBA.
Friday, 14 August 2009
What sid is blocking what
To find out what sid is blocking which sid you can use this query.
select b1.sid, ' IS BLOCKING ', b2.sid
from v$lock b1, v$lock b2
where b1.block =1 and b2.request > 0
and b1.id1=b2.id1
and b1.id2=b2.id2
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment