今天导入数据时,中间点了下停止,然后又重新导入,程序一直卡住不动,经过日志分析,是卡在了一个drop table语句,手动执行该drop table语句,也会卡住,查询该表数据也会卡住。最终查到该表被锁住了,解锁后再drop该表顺利删除成功。
以下是网上的查看锁表和解锁参考:
https://blog.csdn.net/weixin_34414196/article/details/93499456
--查看哪些表被锁住了
select b.owner,b.object_name,a.session_id,a.locked_mode from v$locked_object a,dba_objects b where b.object_id = a.OBJECT_ID;
--查询引起死锁的会话
select b.username,b.sid,b.serial#,logon_time from v$locked_object a , v$session b where a.session_id = b.sid order by b.LOGON_TIME;
--查出sid和serial#
select sid,serial#,paddr from v$session where sid = 259;
--查v$process视图,得到spid
select spid from v$process where addr= '00000003E32BDE28';
--杀死进程(sid,serial#)
alter system kill session '259,37152';