//查询锁表
SELECT t1.SID, t1.serial#, t1.username, t1.logon_time
FROM v$session t1, v$locked_object t2
WHERE t1.SID = t2.session_id
ORDER BY t1.logon_time;
//杀掉锁表进程
ALTER SYSTEM KILL SESSION 'sid, serial#';
COMMIT ;
SELECT t1.SID, t1.serial#, t1.username, t1.logon_time
FROM v$session t1, v$locked_object t2
WHERE t1.SID = t2.session_id
ORDER BY t1.logon_time;
//杀掉锁表进程
ALTER SYSTEM KILL SESSION 'sid, serial#';
COMMIT ;