killing tasks when using MTS

  • From: "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>, <ORACLE-L@xxxxxxxxxxxxx>,<oracledba@xxxxxxxxxxx>, <oracle-databases@xxxxxxxxxxxxxxx>,<oracle-rdbms@xxxxxxxxxxxxxxx>
  • Date: Thu, 04 Mar 2004 09:02:44 -0500

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

Other related posts:

  • » killing tasks when using MTS