1 查询出锁表的 SESS_ID 注意要管理员权限
select * from v
s
e
s
s
i
o
n
s
w
h
e
r
e
t
r
x
i
d
i
n
(
s
e
l
e
c
t
t
r
x
i
d
f
r
o
m
V
sessions where trx_id in (select trx_id from V
sessionswheretrxidin(selecttrxidfromVLOCK where lmode = ‘X’ and table_id <> 0)
– and state=‘ACTIVE’
– and trx_id=‘27547033’
order by create_time desc;
2关闭
SP_CLOSE_SESSION(SESS_ID)