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).