Wednesday, January 9, 2013

Kill Oracle user session from Linux

==== Kill ORACLE user Session from LINUX ===
Identify the Session to be Killed
SQL> select a.username, a.sid, a.serial#, b.spid, a.machine from v$session a, v$process b where a.paddr = b.addr and a.username ='COCERP_12NOV12';
Bash~$ kill -9 SPID
Verify using
Bash~$ ps -ef | grep ora_ | grep -v grep

That's it.