Oracle Server Configuration Options Oracle creates server processes to handle the requests of user processes connected to an instance. A server process can be either a dedicated server process, where one server process services only one user process, or it can be a shared server process, where a server process can service multiple user processes. Shared server processes are a part of Oracle Shared Server architecture. | Usage and Configuration of the Oracle Shared Server Objectives After completing this lesson, you should be able to do the following: Identify the components of the Oracle Shared Server Describe the Oracle Shared Server architecture Configure the Oracle Shared Server Identify and explain usefulness of related data dictionary views Server Configurations Dedicated server process Shared server process Oracle Server Configuration Options Oracle creates server processes to handle the requests of user processes connected to an instance. A server process can be either a dedicated server process, where one server process services only one user process, or it can be a shared server process, where a server process can service multiple user processes. Shared server processes are a part of Oracle Shared Server architecture. Dedicated Server Processes Client Server User process Server process PMON DBWn SMON LGWR CKPT ARCn Instance SGA Dedicated Server Processes The following are some of the . | Usage and Configuration of the Oracle Shared Server Objectives After completing this lesson, you should be able to do the following: Identify the components of the Oracle Shared Server Describe the Oracle Shared Server architecture Configure the Oracle Shared Server Identify and explain usefulness of related data dictionary views Server Configurations Dedicated server process Shared server process Oracle Server Configuration Options Oracle creates server processes to handle the requests of user processes connected to an instance. A server process can be either a dedicated server process, where one server process services only one user process, or it can be a shared server process, where a server process can service multiple user processes. Shared server processes are a part of Oracle Shared Server architecture. Dedicated Server Processes Client Server User process Server process PMON DBWn SMON LGWR CKPT ARCn Instance SGA Dedicated Server Processes The following are some of the features of the dedicated server process configuration: The user process and server process are separate. Each user process has its own server process. The user and server processes can run on different machines to take advantage of distributed processing. There is a one-to-one ratio between the user and server processes. Even when the user process is not making a database request, the dedicated server exists but remains idle. The program interface that is in use depends on whether the user and the dedicated server processes are on the same machine. If they are, the host operating system’s interprocess communication (IPC) mechanism is used for the program interface between processes. Oracle Shared Server Shared server processes Database server Client Snnn Snnn User process User process Snnn Instance SGA Dispatcher D003 Dispatcher D001 Dispatcher D002 The Oracle Shared Server The Oracle Shared Server configuration enables shared servers, dedicated servers, and combined users and servers to .
