oracle 锁进程杀不掉怎么处理

2024-11-25 08:33:50
推荐回答(1个)
回答1:

查看锁表进程SQL语句:
select * from v$session t1, v$locked_object t2 where t1.sid = t2.SESSION_ID;
杀掉锁表进程:
alter system kill session 'SID,serial#';