Database Administration (MOSC)

MOSC Banner

cannot kill session

edited Mar 7, 2019 12:07PM in Database Administration (MOSC) 17 commentsAnswered ✓

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center