步骤1:查看被锁表,获取session_id,SERIAL#
select a.session_id,c.SERIAL#,a.locked_mode, b.owner,b.object_name
From v
l
o
c
k
e
d
o
b
j
e
c
t
a
,
d
b
a
o
b
j
e
c
t
s
b
,
v
locked_object a,dba_objects b,v
lockedobjecta,dbaobjectsb,vsession c
Where b.object_id = a.object_id and c.sid = a.SESSION_ID;
步骤2:解锁
alter system kill session ‘session_id,serial#’
oracle解决数据库锁表问题
最新推荐文章于 2022-01-16 16:01:50 发布