1、查询被锁的数据对象
select *
from v$locked_object l, dba_objects o, v$session s
where l.object_id = o.object_id
and l.session_id = s.sid;
2、解锁
杀死数据库会话
alter system kill session '207,707';– 207为SID, 707为SERIAL#
1、查询被锁的数据对象
select *
from v$locked_object l, dba_objects o, v$session s
where l.object_id = o.object_id
and l.session_id = s.sid;
2、解锁
杀死数据库会话
alter system kill session '207,707';– 207为SID, 707为SERIAL#