RE: Problems Killing Sessions

I apologise. I think I haven't answered you yet.

I suppose that you solved it. However and advice for the future, you gonna notice whether it is using resources when it has locks. So, issue a query over v$lock with the sid of the dying session.

Also for the next time, try using kill stmt. I think 8.1.6 has an alter system disconnect session with a clause that it is as strong as a kill stmt.

Regards.

> -----Mensaje original-----
> De: Eriovaldo do Carmo Andrietta [SMTP:eca_at_widesoft.com.br]
> Enviado el: lunes 12 de marzo de 2001 13:11
> Para: Multiple recipients of list ORACLE-L
> Asunto: Re: Problems Killing Sessions
>
> Friend Christian :
>
> We are thankfull for your help.
> We checked the view v$session_wait as you said.
> The session is there with the informations bellow :
>
> SID=35
> SEQ#=24845
> EVENT=SQL*Net message from client
> P1TEXT=driver id
> P1=1413697536 P1RAW=54435000
> P2TEXT=#bytes
> P2=1
> P2RAW=00000001
> P3TEXT=
> P3=0
> P3RAW=00
> WAIT_TIME=-2
> SECONDS_IN_WAIT=954539
> STATE=WAITED UNKNOWN TIME
>
> We would like to turn off this session, because we are afraid that it
> disturbs us when we will need to put the database down ...
> We donīt know if it is using resources ...
>
> Are there any clue ?
>
> Regards
>
> Eriovaldo do Carmo Andrietta
> eca_at_widesoft.com.br
> Widesoft Sistemas Ltda.
> Limeira/SP - Brasil
> ICQ #102604225
>
>
> ----- Original Message -----
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Sent: Monday, March 12, 2001 5:30 AM
>
>
> 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).
>
> --
> 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).