11 Replies Latest reply: Jan 24, 2013 7:55 AM by seago RSS

    can not kill a session

    seago
      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