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 Received on Fri Mar 21 2003 - 07:56:02 CST