From oracle-l-bounce@freelists.org Tue Aug 30 08:19:27 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j7UDJQqw002337 for ; Tue, 30 Aug 2005 08:19:26 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j7UDJKIP002299 for ; Tue, 30 Aug 2005 08:19:21 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 046F01E7518; Tue, 30 Aug 2005 08:19:17 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 19292-07; Tue, 30 Aug 2005 08:19:16 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 719241E74ED; Tue, 30 Aug 2005 08:19:16 -0500 (EST) Message-Id: Date: Tue, 30 Aug 2005 09:17:05 -0400 From: "Jeffrey Beckstrom" To: , , , , Subject: killed sessions do not kill Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=_14364E77.9DFCEAD0" X-archive-position: 24727 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: JBECKSTROM@gcrta.org Precedence: normal Reply-To: JBECKSTROM@gcrta.org X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-1.2 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE, SUSPICIOUS_RECIPS autolearn=no version=2.63 --=_14364E77.9DFCEAD0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit We are running 9.2.0.6 with shared server (MTS). On some databases, if we kill a session the session does not go into a "killed" status and in fact nothing happens. If we do the same via OEM, the session immediately is killed. Any ideas? Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 --=_14364E77.9DFCEAD0 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Content-Description: HTML

We are running 9.2.0.6 with shared server (MTS).

On some databases, if we kill a session the session does not go into a "killed" status and in fact nothing happens. If we do the same via OEM, the session immediately is killed.

Any ideas?

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113

--=_14364E77.9DFCEAD0-- -- http://www.freelists.org/webpage/oracle-l