参考这个：
https://eco.dameng.com/community/article/a1ed3e70af0983be9808368372ce9514

1.查看当前所有会话：
select * from V$SESSIONS;
找对阻塞的SESS_ID
2.调用系统过程来强制关闭该会话解锁：
SP_CLOSE_SESSION(SESS_ID);

--已执行未提交的sql
select
t1.sql_text,
t1.state ,
t1.trx_id
from
v$sessions t1,
v$trx t2
where
t1.trx_id=t2.id
and t1.state ='IDLE'
and t2.status='ACTIVE';

--kill掉当前的锁
call sp_close_session(SESS_ID);