make a job to delete the sniped sessions
Hello,
It is possible to make a job to delete the all sniped sessions. In routine I used the technique to make a spool file which have all sniped sessions info.
This is as follow :
SET PAGES 100
SET LIN 3200
spool c:\kill1.sql;
SELECT 'ALTER SYSTEM KILL SESSION '||''''||SID||','||SERIAL#||''''||';'
FROM V$SESSION WHERE STATUS='SNIPED';
spool off;
@c:\kill1.sql;
Now Kill1.sql execute and kill all the sessions. How to make a job, or a job can make or read the text file.
Help in this regaurds
Thanking You,