oracle查看锁表对象和杀锁--查询锁表select a.SID,a.SERIAL# from v$session a , v$locked_object b where
oracle查看锁表对象和杀锁
--查询锁表
select a.SID,a.SERIAL# from v$session a , v$locked_object b where a.SID = b.SESSION_ID;
--杀锁
alter system kill session 'sid,serial#'