摘要：
CREATE OR REPLACE PROCEDURE kill_processes ISv_c_kill varchar2(80);BEGIN/* WARNING: If you use MTS (Shared Server) do not kill Shared server processes*/ FOR i IN (select sid,serial# from v$session where status='INACTIVE') LOOP V_c_kill := 'ALTER SYSTEM KILL SESSION ' ||''' 阅读全文