找到卡住的session1 看v$session 里面的应用程序名,主机名等信息。 2 alter system kill session 'sid#,serial#';
truncate 表应该非常快的吧。 估计是这张表被锁住了吧。 杀掉进程吧
--查询表锁 SELECT /*+ rule */ lpad(' ', decode(l.xidusn, 0, 3, 0)) || l.oracle_username User_name, o.owner, o.object_name, o.object_type, s.sid, s.serial# FROM v$locked_object l, dba_objects o, v$session s WHERE l.object_id = o.object_id AND l.session_id = s.sid ORDER BY o.object_id, xidusn DESC;--下面的sid,serial#用上面的相应字段替换 ALTER system kill session 'sid,serial#';
或者
CTL+C
2 alter system kill session 'sid#,serial#';
估计是这张表被锁住了吧。
杀掉进程吧
SELECT /*+ rule */
lpad(' ', decode(l.xidusn, 0, 3, 0)) || l.oracle_username User_name,
o.owner,
o.object_name,
o.object_type,
s.sid,
s.serial#
FROM v$locked_object l, dba_objects o, v$session s
WHERE l.object_id = o.object_id
AND l.session_id = s.sid
ORDER BY o.object_id, xidusn DESC;--下面的sid,serial#用上面的相应字段替换
ALTER system kill session 'sid,serial#';
用plsql develop 工具 杀到那个进程就可以了。