Oracle数据库解决锁表问题
1、首先找到锁表用户的实例id和序列号
select t2.username,t2.sid,t2.serial#,t2.logon_time
from v$locked_object t1,v$session t2
where t1.SESSION_ID = t2.SID order by t2.LOGON_TIME;
2、然后根据找到的实例id和序列号,进行session排杀
alter system kill session ‘sid,serial#’;//(例:204,3925)
整理不易,能点赞就点个赞吧 蟹蟹。