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: [EMAIL PROTECTED] > 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:[EMAIL PROTECTED] > > 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:[EMAIL PROTECTED] > 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" <[EMAIL PROTECTED]> > 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: [EMAIL PROTECTED] > > 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:[EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] > > > > 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: [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.net -- Author: Jared Still INET: [EMAIL PROTECTED] 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: [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).