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';
