oracle数据库锁表查询及杀掉锁表历程SQL
oracle数据库锁表查询及杀掉锁表进程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 ;