Oracle 如何檢視及解開 Lock

針對 Oracle 的 Lock 可透過下列語法去檢視目前被 Lock 的有哪些物件

select t2.sid || ',' || t2.serial#,b.owner,b.object_name,l.session_id,l.locked_mode
from v$locked_object l, dba_objects b,v$session t2
where b.object_id=l.object_id and l.session_id=t2.sid

接著再用以下 sql 去 kill 掉該 Session 即可

alter system kill session 'sid,serial#';