From oracle-l-bounce@freelists.org Thu Mar 4 07:59:56 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i24DxuX27748 for ; Thu, 4 Mar 2004 07:59:56 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i24Dxto27743 for ; Thu, 4 Mar 2004 07:59:55 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9E171394E00; Thu, 4 Mar 2004 09:00:13 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 04 Mar 2004 08:59:06 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from gcrta.org (clevelandrta.org [209.49.247.27]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 70D8A394DE0 for ; Thu, 4 Mar 2004 08:59:02 -0500 (EST) Received: from MAIN-Message_Server by gcrta.org with Novell_GroupWise; Thu, 04 Mar 2004 09:03:01 -0500 Message-Id: X-Mailer: Novell GroupWise Internet Agent 5.5.3.1 Date: Thu, 04 Mar 2004 09:02:44 -0500 From: "Jeffrey Beckstrom" To: , , , , Subject: killing tasks when using MTS Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=_5D7C5705.523375F7" X-archive-position: 298 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: oracle-l@freelists.org X-list: oracle-l --=_5D7C5705.523375F7 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable We are converting from dedicated to shared servers for some of our = connections.=20 With dedicated servers, we often used orakill to terminate the thread = instead of kill session. Kill session would sometimes not get rid of the = connection particularly if the user had turned off the PC, etc. With = shared server, if do an orakill on the thread, you would be terminating = numerous connections. SO how do you get rid of a mts session? =20 =20 Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 --=_5D7C5705.523375F7 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Description: HTML

We are converting from dedicated to shared servers for some of our=20 connections.

With dedicated servers, we often used orakill to = terminate=20 the thread instead of kill session. Kill session would sometimes not get = rid of=20 the connection particularly if the user had turned off the PC, etc. = With=20 shared server, if do an orakill on the thread, you would be terminating = numerous=20 connections. SO how do you get rid of a mts session?

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

--=_5D7C5705.523375F7-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------