脚本杀用户

最新推荐文章于 2024-06-08 21:06:51 发布

原创最新推荐文章于 2024-06-08 21:06:51 发布 · 814 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#脚本 #session #exception #system #kill #c

oracle问题专栏收录该内容

11 篇文章

订阅专栏

connect system/qhdlgis@qhgis1;
declare
cursor c is select sid,a.SERIAL# from v$session a where a.username='SDE' ;
begin
for c1 in c loop
   begin
   dbms_output.put_line('alter system kill session '||''''||c1.sid||','||c1.SERIAL#||'''');
   execute immediate 'alter system kill session '||''''||c1.sid||','||c1.SERIAL#||'''';
   exception when others then
     null;
   end;
end loop;
end;
/

connect system/qhdlgis@qhgis2;
declare
cursor c is select sid,a.SERIAL# from v$session a where a.username='SDE' ;
begin
for c1 in c loop
   begin
   dbms_output.put_line('alter system kill session '||''''||c1.sid||','||c1.SERIAL#||'''');
   execute immediate 'alter system kill session '||''''||c1.sid||','||c1.SERIAL#||'''';
   exception when others then
     null;
   end;
end loop;
end;
/