oracle表被锁定的完美解决方法

/*查询哪些对象被锁*/

/*

https://www.jb51.net/article/118085.htm

*/

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 '24,111'; /*(