04_oracle锁表解锁语句
–oracle锁表解锁语句
–1.查询哪些对象被锁
select object_name,machine,s.sid,s.serial#
from v
l
o
c
k
e
d
o
b
j
e
c
t
i
,
d
b
a
o
b
j
e
c
t
s
o
,
v
locked_object i,dba_objects o,v
lockedobjecti,dbaobjectso,vsession s
where i.OBJECT_ID=o.OBJECT_ID and i.SESSION_ID=s.SID;
–2.杀死相关进程（其中’sid,serial#’)
alter system kill session ‘304,11041’;