“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, and I am also a naturalized Swedish citizen. I am a former Oracle ACE and, to keep up with academic research, I am a Computer Scientist with an MSc in Data Science and another MSc in Software Engineering. I have over ten years of experience working with companies such as IBM, Epico Tech, and Playtech across three different countries (Brazil, Hungary, and Sweden), and I have joined projects remotely in many others. I am super excited to share my interests in Databases, Cybersecurity, Cloud, Data Science, Data Engineering, Big Data, AI, Programming, Software Engineering, and data in general.
(Continue reading)