General: Routing

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

Always Use Dedicated Server

Choose to force the listener to spawn a dedicated server for all network sessions from this client. It does this by adding (SERVER= DEDICATED) to the CONNECT_DATA portion of connect descriptors. Connections from this client use dedicated servers, even if multi-threaded server (MTS) is configured.

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

| Note: This option, if enabled, overrides the Connect Type option in the Service Attributes property sheet.

Prefer Connection Manager Routing

Choose to send the client to an Oracle Connection Manager whenever possible. If no Oracle Connection Manager addresses are available, then connections are routed through any available listener address.

| Note: If you are using Oracle Connection Manager with Oracle Names, then this option must be set on clients and Oracle Names servers.

| See Also: Route Connection Requests