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 ----- From: "Stefan Jahnke" <Stefan.Jahnke_at_bov.de> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, March 21, 2003 8:53 AM Subject: Remove killed session from v$session

> 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 Fri Mar 21 2003 - 08:37:16 CST