Important Oracle 11g changes to alter session kill session

Important Oracle 11g changes to alter session kill session

SQL> select inst_id,sid,serial# from gv$session where username='MYUSER';

   INST_ID        SID    SERIAL# 
---------- ---------- ---------- 
         1        36        11593

SQL>  alter system kill session '36, 11593,1'; 
 alter system kill session '36, 11593,1' 
* 
ERROR at line 1: 
ORA-00026: missing or invalid session ID

Now, it works:

SQL>  alter system kill session '36,11593,@1';

Check the jobs on below query

SQL>  select job from dba_jobs where log_user='MYUSER';

no row found

REFERENCE

https://forums.oracle.com/thread/1247362

Else 

SQL>select s.sid, s.serial#, s.status, p.spid from v$session s, v$process p where s.username = 'MYUSER' and p.addr (+) = s.paddr;

SID           SERIAL# STATUS    SPID

----------   ----------    --------       ------------
168               26          INACTIVE 4567318

SQL>!kill -9 4567318           - (kill the process in OS level)