select session_id from v$locked_object; --查询结果767
SELECT sid, serial#, username, osuser FROM v$session where sid = 767;--详细信息
ALTER SYSTEM KILL SESSION '767,25235'; --根据sid 和serial# 解锁
select session_id from v$locked_object; --查询结果767
SELECT sid, serial#, username, osuser FROM v$session where sid = 767;--详细信息
ALTER SYSTEM KILL SESSION '767,25235'; --根据sid 和serial# 解锁