Oracle commands to query deadlocks and kill sessions

This article mainly introduces "Oracle query deadlock and kill session command", in the daily operation, I believe many people in Oracle query deadlock and kill session command problems have doubts, small make up all kinds of information, sort out simple and easy to use operation method, hope to answer "Oracle query deadlock and kill session command" doubts helpful! Next, please follow the small series to learn together!

select object_name,machine,s.sid,s.serial# from v$locked_object l,dba_objects o ,v$session wherever l.object_id = o.object_id and l.session_id=s.sid;alter system kill session '1142,39701'; At this point, the study on "Oracle query deadlock and kill session command" is over, hoping to solve everyone's doubts. Theory and practice can better match to help you learn, go and try it! If you want to continue learning more relevant knowledge, please continue to pay attention to the website, Xiaobian will continue to strive to bring more practical articles for everyone!