cannot kill session
Oracle 12.1.0.2 SE-2
Oracle Linux 6
This just isn't my day!
The sessions that won't die. I don't even recall connecting to this database at the time these sessions indicate. And when I try to kill them ... nada.
SQL> @chk_sessSQL> col username for a10SQL> col osuser for a10SQL> select sid, 2 serial#, 3 username, 4 osuser, 5 status, 6 to_char(logon_time,'dd-mon-yyyy hh24:mi:ss') logon_time 7 from v$session 8 where upper(username)='ESTEVENS' 9 order by username 10 / SID SERIAL# USERNAME OSUSER STATUS LOGON_TIME---------- ---------- ---------- ---------- -------- -------------------- 199 18081 ESTEVENS INACTIVE 06-mar-2019 07:33:40 126 61136 ESTEVENS INACTIVE 06-mar-2019 07:33:40SQL>SQL> alter system kill session '199, 18081' immediate;
0