Oracle查询死锁&杀死会话

select object_name , machine , s.sid , s.serial# 

from v$locked_object l , dba_objects o , v$session s

where l.object_id　 = 　o.object_id and l.session_id = s.sid ;

 

alter system kill session '1142,39701' ;

转载于:https://www.cnblogs.com/surinfo/p/6269725.html