Oracle database - Dispatcher and Shared Server Process

Card Puncher Data Processing


Oracle Database Shared Server

The shared server architecture uses a dispatcher process to direct client connections to a common request queue. An idle shared server process from a shared pool of server processes picks up a request from the common queue.

This approach enables a small pool of server processes to serve a large number of clients. A significant advantage of the shared server model over the dedicated server model is reduced system resources, enabling support of an increased number of users.

A process that enables many clients to connect to the same server without the need for a dedicated server process for each client.

The dispatcher as Service Handler handles and directs multiple incoming network session requests to shared server processes.

A dispatcher can support multiple client connections concurrently. Each client connection is bound to a virtual circuit. A virtual circuit is a piece of shared memory used by the dispatcher for client database connection requests and replies.

Listener Actions with a Dispatcher

The listener uses the dispatcher as a type of service handler to which it can direct client requests. When a client request arrives, the listener performs one of the following actions:

  • Hands the connection request directly to a dispatcher.
  • Issues a redirect message to the client, containing the protocol address of a dispatcher. The client then terminates the network session to the listener and establishes a network session to the dispatcher, using the network address provided in the redirect message.

The listener uses direct hand off whenever possible. Redirect messages are used, for example, when dispatchers are remote to the listener.

Direct Hand-Off to a Dispatcher Redirected Connection to a Dispatcher
Oracle Database Direct Hand Off To A Dispatcher Oracle Database Redirected Connection To A Dispatcher
1 - The listener receives a client connection request.
2 - The listener hands the connect request directly
to the dispatcher.
3 - The client is now connected to the dispatcher
1 - The listener receives a client connection request.
2 - The listener provides the location of the dispatcher
to the client in a redirect message.
3 - The client connects directly to the dispatcher.

Discover More
Card Puncher Data Processing
Oracle Database - Connect Descriptor (TNS Connect String)

The Connect Descriptor (known also as TNS Connect String) is a type of connect identifier. It defines the parameters that need the Oracle Net Service to connect to a database service : the protocol...
Oracle Database Dedicated Server
Oracle Database - Dedicated Server Architecture

In a dedicated server architecture, each client process connects to a dedicated server process. The server process is not shared by any other client. PMON registers information dedicated server processes...
Oracle Database Listener
Oracle Database - Listener

When an database instance starts, it registers itself with a listener using one or more service names. When a client program or database connects to a listener, it requests a connection to a service. ...
Card Puncher Data Processing
Oracle Database - PMON process

A process monitor database process that performs process recovery when a user process fails. PMON is responsible for cleaning up the cache and freeing resources that the process was using. PMON also checks...
Card Puncher Data Processing
Oracle Database - Server Process

A server process is started for each client connection. shared server process Dedicated server process PMON is responsible to check and to restart this process if necessary.
Card Puncher Data Processing
Oracle Database - Service Handler

Service handlers act as connection points from the listener to an Oracle database. A service handler can be a: dispatcher in shared server configuration or a dedicated server process, or pooled....
Oracle Database Service Registration
Oracle Database - Service Registration

A feature by which the PMON process automatically registers information with a listener. Because this information is registered with the listener, the listener.ora file does not need to be configured with...
Card Puncher Data Processing
Oracle Database - Session Data Unit (SDU) parameter

SDU is a buffer that Oracle Net uses to place data before transmitting it across the network. Oracle Net sends the data in the buffer either when requested or when it is full. Under typical database configuration,...
Card Puncher Data Processing
Oracle Database - Virtual circuit

A virtual circuit is a piece of shared memory used by the dispatcher for client database connection requests and replies.

Share this page:
Follow us:
Task Runner