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;

/

本文轉自 rm_rf_db 51CTO部落格，原文連結：http://blog.51cto.com/12185273/2066558，如需轉載請自行聯系原作者