--查询所有的死锁:
SELECT * FROM V$LOCK;
--查询所有的会话:
SELECT * FROM V$SESSION;
--查询所有的死锁的会话:
SELECT SN.SID,
SN.SERIAL#,
SN.USERNAME,
SN.MACHINE,
SN.TERMINAL,
SN.PROGRAM,
SN.TYPE
FROM V$SESSION SN
WHERE SN.SID IN (SELECT LK.SID FROM V$LOCK LK);
------------------------------------------------------------
SELECT 'ALTER SYSTEM KILL SESSION '''||SN.SID||','||SN.SERIAL#||''';'
FROM V$SESSION SN
WHERE SN.SID IN (SELECT LK.SID FROM V$LOCK LK);
-----删除临时表
drop table 临时表名;
或者切换用户后,执行:
select sid, serial#
from v$session
where sid in(select sid
from v$lock
where id1 =
(select object_id
from user_objects where object_name = upper('TMP_ACC38020_Q')));