oracle 表解锁

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                 SID   SERIAL#      LOGON_TIME       SQL_HASH_VALUE
-------------------- ---------- ---------- --------------------------------
IUIM                    69     26799       28-MAY-13         2892509467

释放session

alter system kill session '69,26799 ';