Kill ORACLE session 12c

Question

good morning. I would like to run a command to kill sessions on ORACLE 12C but the only command I know is ALTER SYSTEM KILL SESSION 'sid, serial, @instancia' IMMEDIATE;

But I wanted to kill specific sessions without typing SID and SERIAL always, ex:

WHERE machine LIKE 'BOA BOASRV120'
AND username LIKE 'CONSINCO'
AND PROGRAM = 'w3wp.exe'

Kill all sessions that fall under that WHERE above.

These sessions get INACTIVE status and wanted to kill them to be as 'KILLED';

Is there a way? Thank you

Answer 1

You can build an anonymous block that basically searches your sessions, mounts the command and executes. Behold:

BEGIN     
 FOR reg in (SELECT 'alter system kill session ''' || ses.sid || ',' || ses.serial# ||''''  cmd
               FROM v$session ses
              WHERE machine LIKE 'BOA\BOASRV120'
                AND username LIKE 'CONSINCO'
                AND program = 'w3wp.exe') LOOP                
     EXECUTE IMMEDIATE reg.cmd;     
 END LOOP; 
END;