--检查哪些被锁
select * from v$locked_object c;
--查询被锁对象名
select * from dba_objects a where a.object_id=273583;
--查询session
select * from v$session b where b.SID=2346;-- sid=2346 serial#=6492
--杀掉session
alter system kill session '2346,6492' immediate;
select * from v$locked_object c;
--查询被锁对象名
select * from dba_objects a where a.object_id=273583;
--查询session
select * from v$session b where b.SID=2346;-- sid=2346 serial#=6492
--杀掉session
alter system kill session '2346,6492' immediate;