SJM wrote:When talking about shared vs. dedicated server "mode", it's not an either/or situation. It can always accept dedicated connections. Setting shared_servers simply creates dispatchers to allow shared connections in addition to dedicated connections. The client tells what kind of connection he wants, via the syntax used in the tnsnames.ora entry.
Oracle Database 11g Enterprise Edition Release 22.214.171.124.0 - Production
If I create a database using dbca, and select dedicated server mode, then it is setup with shared_servers=1.
I was under the impression, as described in the documentation, that this implies shared server mode and a value of 0 is dedictaed server mode?
Can anyone shed any light on this? Thanks.