select t2.username, t2.sid, t2.serial#, t2.logon_time, t2.sql_hash_value from v$locked_object t1,v$session t2 where t1.session_id=t2.sid order by t2.logon_time;
查询结果
USERNAME
-------------------- ---------- ---------- --------------------------------
IUIM
释放session
alter system kill session '69,26799 ';