9 - 10  Net8 Administator’s Guide
Overriding MTS on Clients
If the database is configured for MTS and a particular client requires a dedicated
server, the client can be configured to use a dedicated server in one of the following
ways:
n A net service name can be configured with a connect descriptor that contains
(SERVER=DEDICATED) in the CONNECT_DATA section. For example:
sales=
(description=
(address=(protocol=tcp)(host=sales-server)(port=  1521 ))
(connect_data=
(service_name=sales.us.acme.com)
(server=dedicated)))
n The client profile (sqlnet.ora file) can be configured with USE_
DEDICATED_SERVER=ON. This adds (SERVER=DEDICATED) to the
CONNECT_DATA section of the connect descriptors the client uses. For
example:
use_dedicated_server=on
Note: If USE_DEDICATED_SERVER is set to ON, existing
(SERVER=value) entries are overwritten with
(SERVER=DEDICATED).