Re: Problems Killing Sessions

From: Eriovaldo do Carmo Andrietta <eca_at_widesoft.com.br>
Date: Mon, 12 Mar 2001 04:44:52 -0800
Message-ID: <F001.002C96BC.20010312041047@fatcity.com>

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

Received on Mon Mar 12 2001 - 06:44:52 CST