Re: AW: Remove killed session from v$session

Using orakill will not make the rollback happen any faster.

My use of orakill and kill -9 is due to Oracle's sporadic habit of not cleaning up killed sessions, especially those holding a lock on a table.

Using orakill won't hurt anything either, but if there is a big transaction taking place in the session you kill, it will still need time to rollback.

Jared

On Monday 24 March 2003 04:28, Stefan Jahnke wrote:
> Thanks all, the time for the rollback to take place seems to explain why it
> takes so long before the session actually disappears from v$session. It's a
> development system running long data conversion procedures. Hence, there
> will be lots of rollback. ... and I guess I'll opt for orakill then.
>
> Stefan Jahnke
> Consultant
> BOV Aktiengesellschaft
> Voice: +49 201 - 4513-298
> Fax: +49 201 - 4513-149
> mailto: stefan.jahnke_at_nospam.bov.de
> Please remove nospam to contact me via email.
>
> visit our website: http://www.bov.de
> subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp
>
> Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen!
> Weitere Informationen unter +49 201/45 13-240 oder E-Mail an
> mailto:andrea.palluck_at_bov.de.
>
> Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter
> fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten
> wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die
> rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen
> ausschliessen.
>
> As you are probably aware, e-mails sent via the Internet can easily be
> copied or manipulated by third parties. For this reason we would ask for
> your understanding that, for your own protection and ours, we must decline
> all legal responsibility for the validity of the statements and comments
> given above.
>
>
> -----Ursprüngliche Nachricht-----
> Von: Arup Nanda [mailto:orarup_at_hotmail.com]
> Gesendet: Freitag, 21. März 2003 15:39
> An: Multiple recipients of list ORACLE-L
> Betreff: Re: Remove killed session from v$session
>
>
> Stefan,
>
> The session stays in the KILLED status because of a lot of reasons - the
> primary being the rollback being performed for all the changes the session
> did. At some point the session rollback will be complete and the session
> will be removed. Don't worry about the session being there.
>
> HTH.
>
> Arup Nanda
>
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Friday, March 21, 2003 8:53 AM
>
> > Hi list
> >
> > Is there any way to remove a killed session from v$session. Is it even
> > necessary to do that ?
> > I ran this:
> >
> > select spid, status, osuser, s.program from
> > v$process p, v$session s where p.addr=s.paddr
> >
> > To check for the killed processes' spid in order to remove the thread
>
> (it's
>
> > 9.2 on win2k) with orakill.
> > But for the killed process, no process is shown. So, what's left ? Should
>
> I
>
> > even bother or just wait
> > till Oracle removes the killed session ?
> >
> > Regards,
> > Stefan
> >
> > Stefan Jahnke
> > Consultant
> > BOV Aktiengesellschaft
> > Voice: +49 201 - 4513-298
> > Fax: +49 201 - 4513-149
> > mailto: stefan.jahnke_at_nospam.bov.de
> > Please remove nospam to contact me via email.
> >
> > visit our website: http://www.bov.de
> > subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp
> >
> > Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient
> > schliessen! Weitere Informationen unter +49 201/45 13-240 oder E-Mail an
> > mailto:andrea.palluck_at_bov.de.
> >
> > Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter
> > fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten
> > wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die
> > rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen
> > ausschliessen.
> >
> > As you are probably aware, e-mails sent via the Internet can easily be
> > copied or manipulated by third parties. For this reason we would ask for
> > your understanding that, for your own protection and ours, we must
> > decline all legal responsibility for the validity of the statements and
> > comments given above.
> >
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Stefan Jahnke
> > INET: Stefan.Jahnke_at_bov.de
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > 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
Received on Mon Mar 24 2003 - 10:15:10 CST