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 -> Re: I kill it and it just won't die

Re: I kill it and it just won't die

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Tue, 31 May 2005 01:16:23 GMT
Message-ID: <Xns9666B9E277DD9SunnySD@68.6.19.6>


"151 Proof" <sm_at_ck.me> wrote in news:IPOme.32677$tt5.17012_at_edtnps90:

> Oracle noob here, trying to kill a session, so I get the SID and
> SERIAL# of the session by selecting from V$SESSION, then issue ALTER
> SYSTEM KILL SESSION SID,SERIAL# IMMEDIATE ... but the session just
> refuses to kick the bucket. I tried the DISCONNECT SESSION option too
> but same result. Connecting as sysdba.
>

The OS proces/thread needs to be killed before Oracle will complete the necessary session cleanup. Received on Mon May 30 2005 - 20:16:23 CDT

Original text of this message

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