本文提供两种查询锁定表进程的方法及对应的SQL语句，并介绍如何通过特定的SQL命令杀死锁定进程，解决数据库中常见的锁表问题。
查看锁表进程SQL语句1：
SELECT object_name, machine, se.sid, se.serial#,
lo.oracle_username,lo.os_user_name
FROM gv$locked_object lo, dba_objects do, gv$session se
WHERE lo.object_id = do.object_id
AND lo.session_id = se.sid;
杀掉锁表进程：
ALTER SYSTEM KILL SESSION 'sid,serial#';
查看锁表进程SQL语句2：
select * from v$session t1, v$locked_object t2 where t1.sid = t2.SESSION_ID;
如有记录表示有lock，记下SID和serial#
alter system kill session '738,1429'
SELECT object_name, machine, se.sid, se.serial#,
lo.oracle_username,lo.os_user_name
FROM gv$locked_object lo, dba_objects do, gv$session se
WHERE lo.object_id = do.object_id
AND lo.session_id = se.sid;
杀掉锁表进程：
ALTER SYSTEM KILL SESSION 'sid,serial#';
查看锁表进程SQL语句2：
select * from v$session t1, v$locked_object t2 where t1.sid = t2.SESSION_ID;
如有记录表示有lock，记下SID和serial#
alter system kill session '738,1429'
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
