本文提供了一种方法来查询数据库中被锁定的表及其相关信息，并展示了如何通过SQL命令杀死导致表锁定的进程。
//查询锁表
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 ;
扫一扫
919
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
