Oracle Database - Dedicated Server Process

Card Puncher Data Processing

About

Oracle Database Dedicated Server

In a dedicated server configuration, the listener starts a separate dedicated server process for each incoming client connection request dedicated to servicing the client. After the session is complete, the dedicated server process terminates. Because a dedicated server process has to be started for each connection, this configuration may require more system resources than shared server configurations.

A dedicated server process is a type of service handler that the listener starts when it receives a client request.

Listener Actions

To complete a client/server connection, one of the following actions occurs:

  • The dedicated server inherits the connection request from the listener.
  • The dedicated server informs the listener of its listening protocol address. The listener passes the protocol address to the client in a redirect message and terminates the connection. The client connects to the dedicated server directly using the protocol address.

One of the preceding actions is selected based on the operating system and the transport protocol.

If the client and database exist on the same computer, then a client connection can be passed directly to a dedicated server process without going through the listener. This is known as a bequeath protocol. The application initiating the session spawns a dedicated server process for the connection request. This happens automatically if the application used to start the database is on the same computer as the database.

In order for remote clients to connect to dedicated servers, the listener and the database instance must be running on the same computer.

Connection to a Dedicated Server Process Redirected Connection to a Dedicated Server Process
Oracle Database Connection To A Dedicated Server Process Oracle Database Redirected Connection To A Dedicated Server Process
1 - The listener receives a client connection request.
2 - The listener starts a dedicated server process,
and the dedicated server inherits the connection request from the listener.
3 - The client is now connected directly to the dedicated server.
1 - The listener receives a client connection request
2 - The listener starts a dedicated server process.
3 - The listener provides the location of
the dedicated server process to the client in a redirect message.
4 - The client connects directly to the dedicated server.

Documentation / Reference





Discover More
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...
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...
Oracle Database Dedicated Server Processes Handling Connections Through The Connection Broker Process
Oracle Database - Pooled Server Architecture

Database resident connection pooling provides a connection pool in the database server for typical Web application usage scenarios in which an application acquires a database connection, works on it for...
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....



Share this page:
Follow us:
Task Runner