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 shared server 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 Identification 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.
Copyright © 1996, 2009, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.