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