Kill Oracle session

By Santhosh N

There is a simple command to kill the oracle session

You can kill the oracle session by issuing the below command

SQL> alter system kill session 'sid,serial#';

To find the sid and serial#, you can use the follwoing

select * from v$session
or
select sid, serial#, osuser, program
from   v$session;

To kill the session the immediately, you can use this

SQL> alter system kill session 'sid,serial#' immediate;

Kill Oracle session  (1766 Views)