查询被锁的session_id
select session_id from v$locked_object;
查询结果
----------------------
session_id
8
查询被锁session的详细信息
select sid, serial#, username, osuser from v$session where sid = 8;
查询结果
----------------------
sid | serial# | username | osuser
8 | 32509 | root | ww
解锁
alter system kill session '8,32509';