Re: Multi-threaded server ???
Date: 1995/06/16
Message-ID: <3rsdeq$ehm_at_synapse.bms.com>#1/1
mboxberger_at_softart.com (Mark Boxberger) wrote:
>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.
To explicitly request a dedicated server, use the SERVER=DEDICATED clause egs.
(description=
(address=
(protocol=tcp) (port=1521) (node=<server>)
)
(connect_data=
(sid=<sid>)
(server=dedicated)
)
)
define two aliases and then use the appropriate alias
Hope this helps
Anil Sinha
sinha_at_bms.com
>
>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 Fri Jun 16 1995 - 00:00:00 CEST