--查询被锁表
select object_name,machine,s.sid,s.serial#from gv$locked_object 1,dba_objects o,gv$session s where 1.object_id=o.object_id and 1.session id=s.sid;
--释放被锁的表
alter system kill session'1401,44975';
--查询被锁表
select object_name,machine,s.sid,s.serial#from gv$locked_object 1,dba_objects o,gv$session s where 1.object_id=o.object_id and 1.session id=s.sid;
--释放被锁的表
alter system kill session'1401,44975';