RE: Problems Killing Sessions

I supposed you have already solved. However, I didn't advise you look if the serial# number was increasing. Also to look at which event it was waiting with v$session_wait. Probably sql*net message from client. That why I said those things about the ways of killing.

Regards.

> -----Mensaje original-----
> De: Eriovaldo do Carmo Andrietta [SMTP:eca_at_widesoft.com.br]
> Enviado el: viernes 9 de marzo de 2001 12:16
> Para: Multiple recipients of list ORACLE-L
> Asunto: Re: Problems Killing Sessions
>
> Friend Christian :
>
> Our session is up yet, and ACTIVE.
> We have already seen this situation but status was KILLED, for us it is
> strange.
>
> In v$transaction this sessions doesn´t exist.
>
> About the sequence of commands you said, it actualy happened
> We applyed several commands in several sequences ...
>
> but the session is ACTIVE yet
>
> Are there anyway ?
>
>
> Eriovaldo do Carmo Andrietta
>
> ----- Original Message -----
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Sent: Friday, March 09, 2001 7:30 AM
>
>
> > Maybe two things have happened. First, you probably kill it when it was
> > busy. Or second, you kill it through Oracle first and then when you've
> seen
> > that it hasn't died, you insisted issuing a kill stmt. Sometimes killing
> > through OS, gets you the same result.
> >
> > So now, you must wait for PMON finishing its tasks. Or if you can do it,
> > bounce the database.
> >
> > Sometimes it helps an oradebug wakeup:
> >
> > oradebug wakeup 2 <-----------the orapid of PMON
> >
> > to post PMON and help it to its labour.
> >
> > Regards.
> >
> > > -----Mensaje original-----
> > > De: Eriovaldo do Carmo Andrietta [SMTP:eca_at_widesoft.com.br]
> > > Enviado el: jueves 8 de marzo de 2001 18:36
> > > Para: Multiple recipients of list ORACLE-L
> > > Asunto: Re: Problems Killing Sessions
> > >
> > >
> > > Friends :
> > >
> > > We have a problem for kill a session :
> > >
> > > We did :
> > >
> > > select * from v$session and got the result bellow :
> > >
> > > USERNAME SID SERIAL# STATUS SERVER
> > > ------------------------------ ---------- ---------- --------
> ---------
> > > 1 1 ACTIVE
> DEDICATED
> > > 2 1 ACTIVE
> DEDICATED
> > > 3 1 ACTIVE
> DEDICATED
> > > 4 1 ACTIVE
> DEDICATED
> > > 5 1 ACTIVE
> DEDICATED
> > > USER01 35 55317 ACTIVE DEDICATED
> > >
> > >
> > > We applyed the command :
> > >
> > > alter system kill session '35,55317';
> > > alter system kill session '35,55317'
> > > *
> > > ERROR at line 1:
> > > ORA-00030: user session ID does not exist
> > >
> > > and also, by Instance Manager we finished with kill immediate
> > >
> > > but the session is showed in the Instance Manager and v$session ..
> > >
> > > Why ?
> > >
> > >
> > > Eriovaldo do Carmo Andrietta
> > > eca_at_widesoft.com.br
> > > Limeira/SP - Brasil
> > >
> > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Eriovaldo do Carmo Andrietta
> > > INET: eca_at_widesoft.com.br
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > San Diego, California -- Public Internet access / Mailing Lists
> > > --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You may
> > > also send the HELP command for other information (like subscribing).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Trassens, Christian
> > INET: CTrassens_at_uni2.es
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Eriovaldo do Carmo Andrietta
> INET: eca_at_widesoft.com.br
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Trassens, Christian
  INET: CTrassens_at_uni2.es

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).