General: Routing

The Routing tab enables you to direct connection requests from this machine to a specific process at all times.

Always Use Dedicated Server

Click to force the listener to spawn a dedicated server for all network sessions from this client. Dedicated server processes are committed to one session only and exist for the duration of that session.

(SERVER=DEDICATED) is automatically appended to a connect descriptorÆs connect data. This way, connections from this client will use dedicated servers, even if multi-threaded server (MTS) is configured.

Using this option makes your connection faster, but makes the server slower. Oracle recommends only using this option if you are making massive database transactions with very little idle time.

notice.gif
Note: If enabled, this option overrides the Connect Type option in the Service Attributes property sheet.

Prefer Connection Manager Routing

Click to instruct the client to try to connect to an Oracle Connection Manager whenever possible. Oracle Connection Manager provides support for concentration, multiple protocol support, and Net8 access control functionality.

Addresses that resolve to a Oracle Connection Manager are specially marked in the network configuration for the client. If this option is chosen, these addresses will be used and preferred over other addresses.

seealso.gif
See Also: Route Connection Requests