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
[EMAIL PROTECTED]
Widesoft Sistemas Ltda.
Limeira/SP - Brasil
ICQ #102604225
----- Original Message -----
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
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:[EMAIL PROTECTED]]
> 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 <[EMAIL PROTECTED]>
> 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:[EMAIL PROTECTED]]
> > > 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
> > > [EMAIL PROTECTED]
> > > Limeira/SP - Brasil
> > >
> > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Eriovaldo do Carmo Andrietta
> > > INET: [EMAIL PROTECTED]
> > >
> > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
> >
> > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
