Oracle7 Server Administrator's Guide

Contents Index Home Previous Next

Configuring Oracle7 for Dedicated Server Processes

When a user process executes the database application on one machine, and a server process executes the associated Oracle server on another machine, you have separate, distinct processes. The separate server process created on behalf of each user is a dedicated server process (see Figure 4 - 1). Oracle7 is automatically installed for this configuration. If your operating system can support Oracle7 in this configuration, it may also support multi-threaded server processes.

Figure 4 - 1. Oracle Dedicated Server Processes

To start an instance in a dedicated server configuration, set the following initialization parameters (in the parameter file) to "null", or omit them from the file altogether:

When to Connect to a Dedicated Server Process

If possible, users should connect to an instance via a dispatcher. This keeps the number of processes required for the running instance low. In the following situations, however, users and administrators should explicitly connect to an instance using a dedicated server process:

To request a dedicated server connection, users must include the SRVR=DEDICATED clause in their SQL*Net TNS connect string.

See Also: For a complete description of SQL*Net connect string syntax, see your operating system-specific Oracle documentation and your SQL*Net documentation.

For more information about initialization parameters and parameter files, see the Oracle7 Server Reference.


Contents Index Home Previous Next