查询RAC两节点上的阻塞会话锁

select a.sid,a.serial#,a.status,a.last_call_et,b.type,d.OWNER,d.OBJECT_NAME,d.OBJECT_TYPE 

 from dba_objects d,v$session a,v$lock b,v$locked_object c 

 where a.sid=b.sid 

 and b.sid=c.session_id 

 and c.object_id=d.object_id 

 and b.type='TX' 

 and a.status='INACTIVE' 

 and a.last_call_et>600 

 union all 

 select a.sid,a.serial#,a.status,a.last_call_et,b.type,d.OWNER,d.OBJECT_NAME,d.OBJECT_TYPE 

 from dba_objects@dblink d,v$session@dblink a,v$lock@dblink b,v$locked_object@dblink c 

 where a.sid=b.sid 

 and b.sid=c.session_id 

 and c.object_id=d.object_id 

 and b.type='TX' 

 and a.status='INACTIVE' 

 and a.last_call_et>600