Oracle查看锁，杀会话

select * from v$lock where ctime<3600;

查看哪些会话加锁

 

 

select sid, serial# from v$session where sid='';

根据查出来的sid，查询serial

 

alter system kill session 'sid,serial#';

杀死会话

 

select spid from v$process where addr=(select paddr from v$session where sid=);

kill -9 spid

直接用操作系统命令杀死进程，更常用