查询被锁的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';