killing tasks when using MTS

From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Thu, 04 Mar 2004 09:02:44 -0500
Message-Id: <s046f0c5.058@gcrta.org>

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

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?    

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

---

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

---

To unsubscribe send email to: oracle-l-request_at_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

---

Received on Thu Mar 04 2004 - 07:59:56 CST