Hi all,
Here are 5 Best Practices / Tips for when setting dispatches with Shared Connections:
1. Set local_listener on both instances on the database
alter system set LOCAL_LISTENER=”(address=(
Ref: Shared Server: Dispatchers Are Not Registered With Listener (Doc ID 465881.1)
2. Dispatchers parameter should be set to utilize the VIP name of the host
alter system set dispatchers='(address=(
Ref: How To Configure Shared Server Dispatchers For RAC Environment (Doc ID 578524.1)
3. Dispatchers count should be set appropriately considering the number of sessions expected to connect to the database
A general rule of thumb is that 1 dispatcher can handle 50 shared server connections with minimal performance impact.
Ref: Shared Server Only: TNS-12518, TNS-12564 and TNS-12602 Errors at Connect Time (Doc ID 1539104.1)
4. Arguments can be used with the dispatchers parameter for closer control of how the shared server sessions are used
SESSIONS – Determines the max sessions allowed for each dispatcher.
CONNECTIONS – The maximum number of network connections to allow for each dispatcher.
Ref: https://docs.oracle.com/en/
5. Shared_servers parameter can be set to control total number of shared servers spawned by the database
shared_servers set to 1 –> This will enable shared server sessions on the database.
max_shared_server –> Specifies the maximum number of shared servers that can run simultaneously.
shared_server_sessions –> Specifies the total number of shared server user sessions that can run simultaneously. Setting this parameter enables to reserve user sessions for dedicated servers.
Ref: Automatic Shared Server Configuration (Doc ID 265931.1)
See you next post!