Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> how can I kill a session who's status is "KILLED"?

how can I kill a session who's status is "KILLED"?

From: ceiling <ceiling_at_autumn.ccl.itri.org.tw>
Date: Thu, 13 May 1999 16:35:41 +0800
Message-ID: <7he325$527$1@news.itri.org.tw>


HI ALL:

     In Oracle 8.0.3 Server,there are a session who's status is "KILLED",
        I Need to kill this session because it lock a table,
        but when I try to kill this session,
             "ALTER SYSTEM KILL SESSION 'sid,serial#';
          and get the following error message:
             ORA0---31:session marked for kill,
        and this session still reside in the databse,
          Can anyone tell me how to kill this "KILLED" session.
        Thank You in advance.



Received on Thu May 13 1999 - 03:35:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US