当前位置 博文首页 > 昵称已经被占用咯:oracle执行update时一直执行不了,我这边主要
1、查
SELECT s.sid, s.serial#
FROM v$locked_object lo, dba_objects ao, v$session s
WHERE ao.object_id = lo.object_id
AND lo.session_id = s.sid;
2、删除
ALTER system KILL session 'SID,serial#';