Oracle 数据库表被锁解决方案

-- 查看是否有表被锁了
				
SELECT b.owner,b.object_name,a.session_id,a.locked_mode FROM v$locked_object a,dba_objects b WHERE b.object_id=a.object_id;
-- 查看是哪个进程锁表了
SELECT b.username,b.sid,b.serial#,logon_time FROM v$locked_object a,v$session b WHERE a.session_id=b.sid ORDER BY b.logon_time;
-- 杀掉进程
alter system kill session 'sid,serial#';