查看锁表进程SQL语句:select * from v$session t1, v$locked_object t2 where t1.sid = t2.SESSION_ID;杀掉锁表进程:alter system kill session 'SID,serial#';