运行一程序,用户把表给锁住,下面给出解决方案:[@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,然后一一删除!
用户重新运行程序,解锁成功!