RE: killed sessions staying around

From: MacGregor, Ian A. <ian_at_SLAC.Stanford.EDU>
Date: Tue, 03 Jul 2001 22:14:06 -0700
Message-ID: <F001.00340D87.20010703213548@fatcity.com>

"alter system kill session '<sid>, serial#' immediate;" almost always works. The immediate argument must be include don the first attempt. if you issue, "alter system kill session '<sid>, serial#';" and then issue, "alter system kill session '<sid>, serial#' immediate;", Oracle will respond with "session marked for kill".

Ian MacGregor
Stanford Linear Accelerator Center
ian_at_slac.stanford.edu

-----Original Message-----
Sent: Tuesday, July 03, 2001 5:01 PM
To: Multiple recipients of list ORACLE-L

The trick to succefully killing a session is to kill the OS process first, then kill the
session if it is still lingering.

This is the way it needs to be done on unix, haven't tried it on NT yet, but will soon. :)

Jared

                                                                                       
                       
                    "Jeffrey                                                           
                       
                    Beckstrom"           To:     Multiple recipients of list ORACLE-L 
<ORACLE-L_at_fatcity.com>  
                    <JBECKSTROM_at_g        cc:                                           
                       
                    crta.org>            Subject:     killed sessions staying around   
                       
                    Sent by:                                                           
                       
                    root_at_fatcity.                                                      
                       
                    com                                                                
                       
                                                                                       
                       
                                                                                       
                       
                    07/03/01                                                           
                       
                    01:05 PM                                                           
                       
                    Please                                                             
                       
                    respond to                                                         
                       
                    ORACLE-L

Killed several sessions, but none will terminate. All were connected via ODBC. Users have rebooted, etc. These sessions are several days old and killed today. Was going to try ORAKILL, but there is no thread number. Apparently, entry is on v$session but no corresponding row in v$process. Oracle only suggestion is to exit application gracefully. Oh yeah, like I can enforce that - don't touch the power off switch.

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113
(216) 781-4204

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: Jared.Still_at_radisys.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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.com
--

Author: MacGregor, Ian A.
INET: ian_at_SLAC.Stanford.EDU

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------