39
oracle kill所有plsql developer进程-菜鸡哥哥-51CTO博客
source link: http://blog.51cto.com/12185273/2066558
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
oracle kill所有plsql developer进程
BEGIN
FOR v IN (
SELECT 'alter system kill session ''' || a.sid || ',' || a.serial# || ''' immediate' AS v_sql
FROM v$session a
WHERE a.program in ('plsqldev.exe') ) LOOP
begin
EXECUTE IMMEDIATE v.v_sql;
exception
when others then
commit;
end;
END LOOP;
END;
/
©著作权归作者所有:来自51CTO博客作者rm_rf_db的原创作品,如需转载,请注明出处,否则将追究法律责任
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK