Routing Connection Requests

The client and servers acting as clients can be configured so connection requests are directed to a specific process at all times.

To route connection requests:

  1. Click the Profile icon.

  2. Choose General from the drop-down list box.

  3. Click the Routing tab.

  4. Click the preferred way you want connection requests routed.

    Always Use Dedicated Server:


    Forces the listener to spawn a dedicated server for all network sessions from this client. Server in this sense does not refer to a machine, but to the process on the database side that handles client requests. Server processes can either be shared with other client requests or dedicated. Dedicated server processes are committed to one session only and exist for the duration of that session.
    Note: If enabled, this option will override the Use Dedicated Servers option in the Net Service Name panel. Using this option will make your connection faster, but will make the server slower. It is recommended that unless you are making massive database transactions with very little idle time, do not use this option.


    Prefer Connection Manager Routing:


    Instructs the client to try to use an Oracle Connection Manager whenever possible. Oracle Connection Manager is an application that provides support for concentration, multiple protocol support, and Net8 access control functionality.
    Addresses that resolve to an 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 for a net service name.


  5. Choose Save Network Configuration from the File menu to save changes to SQLNET.ORA in $ORACLE_HOME/network/admin on UNIX or ORACLE_HOME\network\admin on Windows platforms, or choose Save As from the File menu to save under a different file name or path.