“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
*The views expressed here are my own and do not represent those of my employer.*
Hello, I’m Bruno — a dual citizen of Brazil and Sweden. I bring a global perspective shaped by experiences in both South America and Europe, with a strong focus on collaboration and innovation across cultures. I am a Computer Scientist, PhD Candidate in Information and Communication Technologies, focusing on Data Science and Artificial Intelligence, and hold dual Master’s degrees in Data Science and Cybersecurity. With over fifteen years of international experience spanning Brazil, Hungary, and Sweden, I have collaborated with global organizations such as IBM, Playtech, and Oracle, as well as contributed remotely to projects across multiple regions. My professional interests include Databases, Cybersecurity, Cloud Computing, Data Science, Data Engineering, Big Data, Artificial Intelligence, Programming, and Software Engineering, all driven by a deep passion for transforming data into strategic business value.