Thursday, 23 April 2015

How to find locks in RAC database @ instance level?

SQL> select 'SID ' || l1.sid ||' is blocking  ' || l2.sid blocking
from gv$lock l1, gv$lock l2
where l1.block =1 and l2.request > 0
and l1.id1=l2.id1
and l1.id2=l2.id2;
                               OR

SQL> select inst_id, sid, blocking_instance, blocking_session from gv$session
where blocking_instance is not null and blocking_session is not null order by;

No comments:

Post a Comment