| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Re: I kill it and it just won't die
"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
![]() |
![]() |