oracle--常见只KILL 不活跃会话

 

 

 

复制代码
SELECT l.sid,
       s.serial#,
       s.username,
       s.status,
       l.type AS lock_type,
       l.lmode AS mode_held,
       l.request AS mode_requested,
       o.object_name
FROM   v$lock l
JOIN   v$session s ON (l.sid = s.sid)
JOIN   dba_objects o ON (l.id1 = o.object_id)
WHERE  o.object_name = 'RETIRED_250221'
AND    o.object_type = 'TABLE';

SELECT sid, serial#, username, status FROM v$session WHERE username = USER; ALTER SYSTEM KILL SESSION 'SID,SERIAL#';
###### 只想KILL当前用户的不活跃会话:
SET SERVEROUTPUT ON; BEGIN FOR sess IN ( SELECT sid, serial# FROM v$session WHERE username = USER AND status = 'INACTIVE' ) LOOP EXECUTE IMMEDIATE 'ALTER SYSTEM KILL SESSION ''' || sess.sid || ',' || sess.serial# || ''' IMMEDIATE'; DBMS_OUTPUT.PUT_LINE('Killed active session: ' || sess.sid || ',' || sess.serial#); END LOOP; END; /
复制代码

 

posted @   HiJames  阅读(1)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· DeepSeek “源神”启动!「GitHub 热点速览」
· 微软正式发布.NET 10 Preview 1:开启下一代开发框架新篇章
· C# 集成 DeepSeek 模型实现 AI 私有化(本地部署与 API 调用教程)
· DeepSeek R1 简明指南:架构、训练、本地部署及硬件要求
· 2 本地部署DeepSeek模型构建本地知识库+联网搜索详细步骤
点击右上角即可分享
微信分享提示