Does Disabling "Shared Server" Require a Restart Of The Database Instance ?
(Doc ID 2540636.1)
Last updated on JANUARY 30, 2020
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
As title, the database is going to disable the "Shared Server" by issuing the following:
ALTER SYSTEM SET DISPATCHERS ='' scope=both sid='*';
ALTER SYSTEM SET SHARED_SERVERS = 0 scope=both sid='*';
ALTER SYSTEM SET MAX_SHARED_SERVERS = 0 scope=both sid='*';
The question is, after the execution of the SQL. Is it necessary to restart the database server to make the configuration take effect and what will be the expected behavior on both restarting and non-restarting approach?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document