需要用有admin权限的账号登录plsql
语法如下：
--查看被锁的表
select b.owner,b.object_name,a.session_id,a.inst_id,a.locked_mode from gvlocked_object a,gv
session;
--3.查出锁定表的sid, serial#,os_user_name, machine_name, terminal，锁的type,mode
select s.sid,
s.serial#,
s.username,
s.schemaname,
s.osuser,
s.process,
s.machine,
s.terminal,
s.logon_time,
l.type
FROM vlock l
WHERE s.sid = l.sid AND s.username IS NOT NULL ORDER BY sid;
最后，kill的语法：
ALTER SYSTEM KILL SESSION 'sid,serial#'
ALTER SYSTEM KILL SESSION 'sid,serial#，@inst_id'
网友评论