| 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. 5.4.1 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. 5.4.2 sqlnet.ora You can also force the use of dedicated server from the sqlnet.ora file. The following USE_DEDICATED_SERVER parameter, added to sqlnet.ora , forces all connections made from the client to be made using a dedicated server: USE_DEDICATED_SERVER = ON Use of this parameter represents what we refer to as the "shotgun approach." It's not flexible, and it affects every session that you initiate from your client. If you need to make occasional use of a dedicated server connection, we think it's better to create a specific net service name just for that purpose.  | 
