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

/*

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'; /*(其中24,111分别是上面查询出的sid,serial#)*/

/*获得进程(线程)号*/

select spid, osuser, s.PROGRAM

from v$session s, v$process p

where s.PADDR = p.ADDR

and s.SID = '425';

/*杀进程*/

kill - 9 26099 /*查询出的spid*/