Oracle Net8 Configuration and Troubleshooting

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 ...