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
直接用操作系统命令杀死进程,更常用