第一步:用有管理员权限登录oracle
执行如下sql:
select t2.username,
t2.sid,
t2.serial#,
t3.object_name,
t2.OSUSER,
t2.MACHINE,
t2.PROGRAM,
t2.LOGON_TIME,
t2.COMMAND,
t2.LOCKWAIT,
t2.SADDR,
t2.PADDR,
t2.TADDR,
t2.SQL_ADDRESS,
t1.LOCKED_MODE
from v
l
o
c
k
e
d
o
b
j
e
c
t
t
1
,
v
locked_object t1, v
lockedobjectt1,vsession t2, dba_objects t3
where t1.session_id = t2.sid
and t1.object_id = t3.object_id
order by t2.logon_time;
如果存在数据,则代表有表被锁,获取 SID SERIAL#两个字段信息
第二步:执行如下sql删除session即可
alter system kill session ‘sid,seial#’;
例如: alter system kill session ‘1136,54869’;