如何用plsql查询Oracle 未释放发的sql语句
门户网站经常造成数据库死锁，如何用plsql查询Oracle未释放的SQL语句？收起
查看其它 3 个回答墨域非攻的回答
DECLARE
CURSOR SE_LOCK IS
SELECT SID, SERIAL#
FROM V$SESSION
WHERE SID IN (SELECT SESSION_ID FROM V$LOCKED_OBJECT);
COM_STR VARCHAR2(100);
BEGIN
FOR I IN SE_LOCK LOOP
COM_STR := 'ALTER SYSTEM KILL SESSION' || '''' || I.SID || ',' ||
I.SERIAL# || '''';
EXECUTE IMMEDIATE COM_STR;
END LOOP;
END;
直接杀死所有死锁的会话，我自己图方便这么用
CURSOR SE_LOCK IS
SELECT SID, SERIAL#
FROM V$SESSION
WHERE SID IN (SELECT SESSION_ID FROM V$LOCKED_OBJECT);
COM_STR VARCHAR2(100);
BEGIN
FOR I IN SE_LOCK LOOP
COM_STR := 'ALTER SYSTEM KILL SESSION' || '''' || I.SID || ',' ||
I.SERIAL# || '''';
EXECUTE IMMEDIATE COM_STR;
END LOOP;
END;
直接杀死所有死锁的会话，我自己图方便这么用
浏览1213