刪除oracle表被鎖住

執行一程式，使用者把表給鎖住，下面給出解決方案：[@more@]

首先先查出SID，

SELECT SUBSTR(all_objects.owner||'.'||object_name,1,16) "Locked Object"
,SUBSTR(os_user_name,1,10) "Tiptop User"
,v$locked_object.process "Proc ID"
,SUBSTR(terminal,1,7) "Terminal"
,v$session.sid,v$session.serial#
,v$session.machine
FROM v$locked_object,all_objects,v$session
WHERE v$locked_object.object_id=all_objects.object_id
AND v$locked_object.SESSION_ID=v$session.SID

查出SID，

然後在sqlplus '/as sysdba'

alter system kill session 's_id,session_id';

找出相關的sid,sessionid,然後一一刪除！

使用者重新執行程式，解鎖成功！