How does an Oracle shared server differ from a dedicated server?

Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.

How does an Oracle shared server differ from a dedicated server?

Rating:

In a dedicated server process, every user process on a client computer is connected to a separate virtual dedicated server process (shadow process) on the computer on which the Oracle server is installed. Each client's request is processed by a separate dedicated server. The server process provides the dedicated services until the client computer is disconnected from the Oracle server.

Whereas, in an Oracle shared server process, one shared server process serves multiple-user requests.

Following points along with the diagrammatic depiction shows how the Oracle shared server processes a client's request:

• A request from a client is passed to the dispatcher process.
• The client's request is placed on the request queue in system global area (SGA) by the dispatcher.
• The request is then executed by one of the shared servers.
• The completed request is then placed on the dispatcher's response queue in SGA.
• The dispatcher then picks up the completed request.
• The completed request is then passed back to the client.

Rating: