Dispatcher Config In Oracle Database

Oracle Database Dispatchers are essential for managing multiple client connections efficiently. As part of Oracle’s Shared Server architecture, Dispatchers handle requests from clients by routing them to shared server processes. This reduces resource consumption compared to using dedicated server processes for each client.
How Dispatchers Work:
    Client Requests: Clients send requests to the Dispatcher.
    Routing: The Dispatcher assigns the request to an available shared server process.
    Processing: The shared server handles the request and returns the response.
    Response: The Dispatcher sends the result back to the client.
Configuring Oracle Dispatchers
1. Set the DISPATCHERS Parameter
DISPATCHERS = '(PROTOCOL=TCP)(SERVICE=orcl)(DISPATCHERS=4)'
    PROTOCOL=TCP: Specifies the communication protocol.
    SERVICE=orcl: Defines the database service.
    DISPATCHERS=4: Specifies the number of Dispatchers to use.
2. Other Important Parameters
SHARED_SERVERS: Sets the number of shared server processes.
SHARED_SERVERS = 10
MAX_SHARED_SERVERS: Defines the maximum shared server processes allowed.
MAX_SHARED_SERVERS = 50
SERVER: Set this to SHARED for Shared Server architecture.
SERVER = SHARED
3. Make Dynamic Changes
ALTER SYSTEM SET DISPATCHERS='(PROTOCOL=TCP)(SERVICE=orcl)(DISPATCHERS=6)' SCOPE=BOTH SID='*';
ALTER SYSTEM SET DISPATCHERS='(PROTOCOL=TCP)' SCOPE=BOTH SID='*';
4. Multiple Protocols Configuration
DISPATCHERS = '(PROTOCOL=TCP)(SERVICE=orcl)(DISPATCHERS=2)',
              '(PROTOCOL=IPC)(SERVICE=orcl)(DISPATCHERS=2)