KILL Session in Oracle

 

Following query can be used to get all the active sessions.

SELECT SID, SERIAL#, STATUS 

  FROM V$SESSION 

  WHERE USERNAME = 'IFSAPP' 

  AND status = 'ACTIVE';

To Kill any of the above sessions, run the ALTER query below with correct SID and SERIAL.

 ALTER SYSTEM KILL SESSION 'SID,SERIAL';