先用 select t2.username,t3.owner||'.'||t3.object_name object,t2.sid,t2.serial#,t2.logon_time from v$locked_object t1,v$session t2, all_objects t3 where t1.session_id=t2.sid and t1.object_id=t3.object_id order by t2.logon_time查出来 sid和serial的值 比如 sid = 141 , serial = 29 然后使用alter system kill session '141,29'
select t2.username,t3.owner||'.'||t3.object_name object,t2.sid,t2.serial#,t2.logon_time from v$locked_object t1,v$session t2,
all_objects t3 where t1.session_id=t2.sid and t1.object_id=t3.object_id order by t2.logon_time查出来 sid和serial的值 比如 sid = 141 , serial = 29
然后使用alter system kill session '141,29'