Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Remove killed session from v$session

RE: Remove killed session from v$session

From: Anderson, Brian <andersob_at_darton.edu>
Date: Fri, 21 Mar 2003 09:37:48 -0500
Message-Id: <24738.322703@fatcity.com>


It should disappear eventually, it sometimes takes a while. Try the immediate clause next time, they don't usually hang around.

alter system kill session '&sid,&serial' immediate;

> -----Original Message-----
> From: Stefan Jahnke [mailto:Stefan.Jahnke_at_bov.de]
> Sent: Friday, March 21, 2003 8:54 AM
> To: Multiple recipients of list ORACLE-L
> 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:48 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US