Forcing a Dedicated Server Connection
There really are no changes that you need to make to your Net8 configuration files in order to use MTS. Once you’ve configured MTS for an instance, new connections begin using it. What you can do using the Net8 configuration files is override the use of MTS in order to force a dedicated server connection to be made.
tnsnames.ora
Remember that MTS is best used in cases
where a client has a lot of idle time. While one client is idle, a
server process can do work for another. If you’re dealing with
a client or a batch job that requires a high degree of throughput,
and one that won’t have much idle time, you’ll be better
off having them make a dedicated server connection. One way to do
that is to create a separate net service name and add attribute
(SERVER = DEDICATED) to the list of CONNECT_DATA attributes. For
example, if you are using local naming, you could define a net
service name in listener.ora as follows:
HERMAN-DEDICATED.GENNICK.ORG =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)
(HOST = jonathan.gennick.org)
(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = herman.gennick.org)
(SERVER = DEDICATED)
)
)Dedicated server connections can also be configured in Oracle Names. If you are using the command-line interface to Names, the same syntax applies. If you are using the Net8 Assistant, there’s a checkbox on the Advanced Service Options window that allows you to choose dedicated server.
sqlnet.ora
You can also force the use of dedicated ...