This discussion is archived
11 Replies Latest reply: Jan 24, 2013 5:55 AM by seago RSS

can not kill a session

seago Newbie
Currently Being Moderated
I use 'alter system kill session' command to kill a session.but the session always in 'KILLED' status,paddr change to '00', and serial# increasing continually.

version: 10.2.0.4
OS: solaris 10

<pre>
20:58:01 SQL> select sid,serial#,paddr,last_call_et,event,wait_time,blocking_session from v$session where sid=682;

SID SERIAL# PADDR LAST_CALL_ET EVENT WAIT_TIME BLOCKING_SESSION
========== ========== ================ ============ ============================= ========== ================
682 57313 00 12999 SQL*Net message from client 0

20:58:02 SQL> /

SID SERIAL# PADDR LAST_CALL_ET EVENT WAIT_TIME BLOCKING_SESSION
========== ========== ================ ============ ============================= ========== ================
682 57315 00 13008 SQL*Net message from client 0
</pre>

Edited by: seago on 2013-1-22 上午5:19

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points