“With the shared server architecture, many client processes connect to a dispatcher”
“… is useful when a system is overloaded or has limited memory.”
“Shared server is enabled by setting the SHARED_SERVERS initialization parameter to a value greater than 0. The other shared server initialization parameters need not be set.”
– Some parameters:
– SHARED_SERVERS > 0, MAX_SHARED_SERVERSDISPATCHERS, SHARED_SERVER_SESSIONS, MAX_DISPATCHERS, CIRCUITS
“To calculate the initial number of dispatchers to create during instance startup, use the following formula:
Number of dispatchers =
CEIL ( max. concurrent sessions / connections for each dispatcher )”
Good views to check:
V$QUEUE,V$DISPATCHER, V$DISPATCHER_CONFIG, V$DISPATCHER_RATE
TNSNAMES: SERVER=SHARED
Oracle Database Administrator’s Guide -> Managing Processes -> 5.3 Configuring Oracle Database for Shared Server
Database Net Services Administrator’s Guide -> 11 Configuring a Shared Server Architecture
Hi! I am Bruno, a Brazilian born and bred. Former Oracle ACE, Computer Scientist, MSc in Data Science, over ten years of experience in companies such as IBM, Epico Tech, and Playtech based in three different countries (Brazil, Hungary, and Sweden) and joined projects remotely in many others. I am super excited to show you my interest in Databases, Cloud, Data Science, Data Engineering, Bigdata, AI, Programming, Software Engineering, and data in general.
(Continue reading)