CREATE OR REPLACE PROCEDURE proc_kill_inactive_sessions IS
CURSOR kill_sessions_cur
IS
SELECT s.SID, s.serial#
FROM v$session s
WHERE s.status = 'SNIPED';
v_cmd VARCHAR2 (100);
BEGIN
FOR kill_sessions_rec IN kill_sessions_cur
LOOP
v_cmd :=
'Alter system kill session '''
|| kill_sessions_rec.SID
|| ','
|| kill_sessions_rec.serial#
|| ''' immediate';
EXECUTE IMMEDIATE v_cmd;
END LOOP;
END;
/
Actually , I am trying to create procedure for Killing In Active Sessions Automatically , But While Executing this Procedure its returning Error message.