Re: Multi-threaded server ???
Date: 1995/06/15
Message-ID: <3rpmuu$bqt_at_news.tamu.edu>#1/1
In article <3rphs0$ebr_at_cnn.softart.com>,
Mark Boxberger <mboxberger_at_softart.com> 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.
>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.
Yup, this is possible. You can have the e-mail client connect to the Oracle
server process by a dedicated connection by using the clause (SRVR=DEDICATED)
in its SQL*Net TNS connect string. Look in the following place for more info:
Oracle 7 server administrator guide. Chapter 4. Managing Oracle Processes.
Page 9.
You would also have to look at your SQL*Net documentation to configure the
TNS connect string for the e-mail client to connect to the database as a
dedicated connection.
Hope this helps.
Mahesh Vallampati
oracle7_at_tamu.edu
// In the beginning there was Codd...
Received on Thu Jun 15 1995 - 00:00:00 CEST