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: AW: Remove killed session from v$session

RE: AW: Remove killed session from v$session

From: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Mon, 24 Mar 2003 13:56:02 -0500
Message-Id: <24765.322913@fatcity.com>


{innocently} but this *will* take care of the problem, right? :)

-----Original Message-----
From: Jared.Still_at_radisys.com [mailto:Jared.Still_at_radisys.com] Sent: Monday, March 24, 2003 12:59 PM
To: Multiple recipients of list ORACLE-L Subject: 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" <MGogala_at_oxhp.com>
Sent by: root_at_fatcity.com
 03/24/2003 09:18 AM
 Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        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: 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.
>
>
> -----Ursprüngliche Nachricht-----
> Von: Arup Nanda [mailto:orarup_at_hotmail.com]
> 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" <ORACLE-L_at_fatcity.com>
> 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: 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
> > 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: jkstill_at_cybcon.com

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
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gogala, Mladen
  INET: MGogala_at_oxhp.com

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
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: Jared.Still_at_radisys.com

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
Received on Mon Mar 24 2003 - 12:56:02 CST

Original text of this message

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