RE: AW: Remove killed session from v$session
Well, it will kill of your oracle processes and deallocate any shared memory that has been allocated. It will transcend the problem to the different plane of existence. -Original Message- Sent: Monday, March 24, 2003 2:05 PM To: Multiple recipients of list ORACLE-L {innocently} but this *will* take care of the problem, right? :) -Original Message- Sent: Monday, March 24, 2003 12:59 PM To: Multiple recipients of list ORACLE-L Mladen, you really need to put a :) on these, lest some newbie take you seriously. :) Jared "Gogala, Mladen" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 03/24/2003 09:18 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: AW: Remove killed session from v$session This is going to remove killed session from v$session: ps -fu oracle|grep -v PID|awk '{ print $2; }'|xargs kill -9 ipcs -m|grep oracle|awk '{ print $2; }'|xargs ipcrm -m Next time you connect to the database, the killed session will not be visible in the v$session table. -Original Message- Sent: Monday, March 24, 2003 11:14 AM To: Multiple recipients of list ORACLE-L 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
RE: AW: Remove killed session from v$session
{innocently} but this *will* take care of the problem, right? :) -Original Message- Sent: Monday, March 24, 2003 12:59 PM To: Multiple recipients of list ORACLE-L Mladen, you really need to put a :) on these, lest some newbie take you seriously. :) Jared "Gogala, Mladen" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 03/24/2003 09:18 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: AW: Remove killed session from v$session This is going to remove killed session from v$session: ps -fu oracle|grep -v PID|awk '{ print $2; }'|xargs kill -9 ipcs -m|grep oracle|awk '{ print $2; }'|xargs ipcrm -m Next time you connect to the database, the killed session will not be visible in the v$session table. -Original Message- Sent: Monday, March 24, 2003 11:14 AM To: Multiple recipients of list ORACLE-L 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] > > > >
RE: AW: Remove killed session from v$session
I agree. This is, essentially, a unix equivalent of shutdown abort. It kills all oracle processes and removes any shared memory allocated to oracle, even if there is more then one instance on the box. -Original Message- Sent: Monday, March 24, 2003 1:00 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Importance: High Mladen, you really need to put a :) on these, lest some newbie take you seriously. :) Jared "Gogala, Mladen" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 03/24/2003 09:18 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: AW: Remove killed session from v$session This is going to remove killed session from v$session: ps -fu oracle|grep -v PID|awk '{ print $2; }'|xargs kill -9 ipcs -m|grep oracle|awk '{ print $2; }'|xargs ipcrm -m Next time you connect to the database, the killed session will not be visible in the v$session table. -Original Message- Sent: Monday, March 24, 2003 11:14 AM To: Multiple recipients of list ORACLE-L 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 BO
RE: AW: Remove killed session from v$session
This is going to remove killed session from v$session: ps -fu oracle|grep -v PID|awk '{ print $2; }'|xargs kill -9 ipcs -m|grep oracle|awk '{ print $2; }'|xargs ipcrm -m Next time you connect to the database, the killed session will not be visible in the v$session table. -Original Message- Sent: Monday, March 24, 2003 11:14 AM To: Multiple recipients of list ORACLE-L 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 fr
RE: AW: Remove killed session from v$session
Mladen, you really need to put a :) on these, lest some newbie take you seriously. :) Jared "Gogala, Mladen" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 03/24/2003 09:18 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: AW: Remove killed session from v$session This is going to remove killed session from v$session: ps -fu oracle|grep -v PID|awk '{ print $2; }'|xargs kill -9 ipcs -m|grep oracle|awk '{ print $2; }'|xargs ipcrm -m Next time you connect to the database, the killed session will not be visible in the v$session table. -Original Message- Sent: Monday, March 24, 2003 11:14 AM To: Multiple recipients of list ORACLE-L 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 > &
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: [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.
AW: Remove killed session from v$session
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: Arup Nanda 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.