- 查询被锁的表
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
- 查看是哪个session引起的
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
- 杀掉对应进程即解锁
alter system kill session '86,2084'
//其中86是sid 2084是serial#
tips :
这句SQL中session 后面要有空格,不然会报错:
ORA-02000: missing session keyword.