Database Administration (MOSC)

MOSC Banner

CANNOT KILL SESSION

edited Feb 23, 2016 2:02AM in Database Administration (MOSC) 7 commentsAnswered ✓

Hello,

Do you please know why oracle cannot find the session to kill please?,

p1gnf1d1 > select inst_id,sid,serial#,state from gv$session where sid=168 and serial#=45640;

   INST_ID        SID    SERIAL# STATE

---------- ---------- ---------- -------------------

         1        168      45640 WAITING

p1gnf1d1 > ALTER SYSTEM KILL SESSION '168,45640,@1';

ALTER SYSTEM KILL SESSION '168,45640,@1'

*

ERROR at line 1:

ORA-00030: User session ID does not exist.

Thank You

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