Multi-threaded server ???

From: Mark Boxberger <mboxberger_at_softart.com>
Date: 1995/06/15
Message-ID: <3rphs0$ebr_at_cnn.softart.com>#1/1


I am trying to work through an architecture issue regarding the use of ORACLE's MTS. I have a client server app that has two distinct types of users connecting to the DBMS. The first is a typical human user running a remote C/S application, and the second is an E-MAIL type application also running remotely that is generating 5-10 times the number of transactions as the typical human user. Is it possible to configure the DBMS such that the E-MAIL app has a dedicated connection whenever it connects and have the human users connect to a shared server process.

My understanding is that the MTS configuration is server wide, however, can I do anything to force the above architecture? Also, would using SQL*Net V2 and a different protocol on the E-MAIL client force this behavior? Would using SQL*Net V1 on the E-MAIL client force this behavior?

Thanks.

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Kirk, McCoy and Ensign Walker all beam down to the surface of a previously unexplored planet. Who's going to die before the first commercial?
Mark Boxberger (maboxber_at_softart.com) Software Artistry, Inc. The views expressed are mine ...blah, blah, blah ...
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Received on Thu Jun 15 1995 - 00:00:00 CEST

Original text of this message