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#'