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
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)
