Kill Blocking Sessions in RAC

select decode(request,0,'Holder: ','Waiter: ') || gv$lock.sid ses, 'alter system kill session ''||gv$lock.sid||','||gvs.serial#||',@'||gvs.inst_id||''';'  from gv$lock join gv$session gvs  on gv$lock.sid=gvs.sid  and gv$lock.inst_id=gvs.inst_id join gv$locked_object lo  on gv$lock.sid = lo.session_id and gv$lock.inst_id=lo.inst_id join dba_objects do on lo.object_id = do.object_id where (id1, id2, gv$lock.type) in (select id1, id2, type from gv$lock where request>0) order by id1, request;

Command Syntax:

 Alter system kill session 'sid,serial#,@inst_id' ;

copy the generated SQL command and execute.

alter system kill session '1523,3805,@1';